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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 How to create backup without rows of data?

Author  Topic 

bryan42
Starting Member

28 Posts

Posted - 2011-10-08 : 10:23:19
Is there a way to create a database backup that includes everything but the rows of data?

This would make replication setup easier, as I need the database to be on the subscriber with all indexes and users, but all the tables need to be truncated. So far, trying to create such a backup always fails when I right-click on the database and specify such a backup.

Perhaps there's a SQL command that will work?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-08 : 11:49:53
You can generate the schema using SSMS' generate script wizard.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -