chennaiprogrammer
Programmer
- Jul 31, 1999
- 54
If I want to take a backup of an sql server 2000 database (everything the stored procedure, table definitions etc ..basically everything) EXCEPT the stored data what TRANSACT sql should I use ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to backup ms sql server database without data
- Thread starter chennaiprogrammer
- Start date
- Status
what you can do is to generate script for the database. right click on the database, then select "all tasks" then "generate sql scripts". from there, you can select all the objects you want to script or back up. you can then execute the script you generated if you want to recreate the objects.
Andel
Andel
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
