Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mcp111
Starting Member
44 Posts |
 Posted - 2003-06-09 : 16:35:21
|
| How do I make a backup of a SQL Server database with only the structure andnot the data, i.e. I want an empty database |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-09 : 16:40:21
|
| Create a script instead - that will create an empty database when run.Could also create a new database, use dts to copy all the objects with no data then back that up.Could backup the database, restore it, truncate/delete all the tables (do it many times to get rid of any foreign key errors). then back that up.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-09 : 17:11:00
|
| Just generate the schema in Enterprise Manager. Right click on your database and go to generate SQL script. Then pick whichever objects that you want.Tara |
|
|
|
debug
Starting Member
29 Posts |
Posted - 2003-06-10 : 16:13:56
|
| I agree with Tara..on this generating SQL script for the database would be the best solution.DU |
|
|
|
|
|
|
Backup only database structure