Gold
Reputation: 62464
How to backup SQL Server 2008 database - only the objects, without data
How to backup SQL Server 2008 database - only the objects, without data?
Upvotes: 1
Views: 1461
Answers (1)
cjk
Reputation: 46425
Right click on the Database, Choose Taks, then Generate Scripts. This allows you to generate a script that will create all objects.
Upvotes: 6
Related Questions
- Backup a single table with its data from a database in sql server 2008
- How to backup only table data from SQL Server 2008 R2 using C#
- MSSQL DataBase Backup without a specific table
- SQL Server Management Studio: Backup and restore database without data
- Ways to backup database data
- Backup in Sql server 2008
- Database backup SQL Server 2008
- Database backup in SQL Server 2008
- how i can backup all database (sql server 2008) in C# code?
- backup SQL Server 2005 database without data