登入
Microsoft.com
 
Microsoft
 
 
 

none
SQL 2000 Database Backup questions RRS feed

 > 

  • 問題

  • Question
    登入以投票
    0
    登入以投票
    Hi

    I am wondering if there anyway that I could just backup the database structure/schema/stored procedure/view/table? without backing up the data?

    Thanks in advance.

    2008年9月30日 下午 03:04
    |

解答

所有回覆

  • Question
    登入以投票
    0
    登入以投票
    Generate script for the database.

     

    2008年10月1日 下午 03:46
    |
  • Question
    登入以投票
    0
    登入以投票
    Hi Rmiao,

    Thanks for your suggestion, Is there any way that I can do it automatically? E.g. set a schedule to do it? SO that I do not need to Generate script manually all the time.

    Thanks a lot.
    2008年10月1日 下午 08:09
    |
  • Question
    登入以投票
    0
    登入以投票

    Hi,


    Maybe you can write a programme to do this. Here's one FYI:

     

    http://www.codeproject.com/KB/dotnet/SQL_Server_backup.aspx

    2008年10月2日 上午 06:30
    |
    版主
  • Question
    登入以投票
    0
    登入以投票
    Hi Allen

    Thanks very much for your help, The URL you provided above very useful.

    Do you have the script that I can use to Generate Database script? because what I need is just a Generate Script into a txt or any file, so that when I need it I can just open the file and select the stored procedure, user define function that I want and load it back to the database.

    Otherwise, I may need to spend quite a long time to understand how that "SQL_Server_backup" application work and modify the code.

    I tried to read through the code briefly, unfortunately, it does not looks simple.

    Thanks a lot.
    2008年10月2日 上午 08:59
    |
  • Question
    登入以投票
    0
    登入以投票
    You can generate script with scptxfr.exe, it's sql2k tool but works for sql2k5. I use it on my sql2k5 servers.
    2008年10月2日 下午 06:08
    |
  • Question
    登入以投票
    0
    登入以投票
    Hi Rmiao,

    Thanks very much for your information, I am quite dumb, I am not quite sure how to apply it so that I can get a backup structure every day? Do I need to write a batch file or something?

    I would be grateful if you could give me some sample code.

    Thanks a lot.
    2008年10月3日 下午 12:01
    |
  • Question
    登入以投票
    0
    登入以投票

    You can just run it in sql job, get syntax with 'scptxfr.exe /?' in dos prompt.

    2008年10月3日 下午 05:45
    |
  • Question
    登入以投票
    0
    登入以投票
    HI Rmiao,

    Thanks very much for your help, I will try it out Next week

    Thanks a lot = )
    2008年10月3日 下午 07:28
    |