Backup database without data

[Steel811]

Hello,

I would like to backup my SQL server 2000 database, but without the data, basically only keeping the building of the tables and all relationships, etc. Can this be done?

Thanks in advance,
Sheel Shah

 

[gmmastros]

Instead of backing up the database, you would be better off scripting the database instead. (Enterprise manager can do this for you).

Then, if you want a blank copy of your database, simply create a new database and run the scripts.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Steel811]

I'm such a moron. That was exactly correct. I couldn't remember what I needed to do for that. Thank you very much for refreshing my memory George! Much appreciated.

~Sheel