backup SQL Server 2005 database without data

Question

I have one stored procedure to backup the database. It will backup metadata as well as data.

Is there any option to back up the database with out data. ie, back up only the schema (Empty tables).

I don't want to script the database.

You could run TRUNCATE TABLE statements for each table prior to running your backup sproc, assuming you don't care about/need the currently existing data at all. — OMG Ponies
– OMG Ponies, Commented Nov 27, 2009 at 7:06
Duplicate: stackoverflow.com/questions/3589/backup-sql-schema-only — OMG Ponies
– OMG Ponies, Commented Nov 27, 2009 at 7:12

Community · Accepted Answer · 2017-05-23 10:25:24Z

2

There's a solution already on StackOverflow - here.

CommunityBot

11 silver badge

answered Nov 27, 2009 at 7:09

terR0Q

1,3778 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

he doesn't want to script the database though, but neverthless simple solution :)

@Mahesh Velaga But this solution can be scripted as well. If not, that'll be awful as a daily task :)

priyanka.sarkar · Accepted Answer · 2009-11-27 07:41:50Z

0

You can do using SQL SERVER SCRIPT WIZARD

answered Nov 27, 2009 at 7:41

priyanka.sarkar

26.7k43 gold badges133 silver badges182 bronze badges