Backup SQL Schema Only? *

Question

I need to create a backup of a SQL Server 2005 Database that's only the structure...no records, just the schema. Is there any way to do this?

EDIT: I'm trying to create a backup file to use with old processes, so a script wouldn't work for my purposes, sorry

Answer

Use a 3 step process:

1. Generate a script from the working database
2. Create a new database from that script
3. Create a backup of the new database

< br > via < a class="StackLink" href=" http://stackoverflow.com/questions/3589/" >Backup SQL Schema Only?< /a>

Share on Google Plus

About Cinema Guy

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.