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 |
|
Soliqui
Starting Member
1 Post |
 Posted - 2010-10-25 : 05:39:01
|
| How can I back up a database with ONLY the tables and not the rows in it. I can't do it by scripting since it is for a customer... I have two sql servers. 1 is R2 and the other is not. So i can't manually delete all rows..Can anyone help me? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-25 : 05:54:42
|
| No, you can't backup just the data.You can:script the DDL (e.g. then use the script to create the table on another database)export the data in the tables - numerous formats are available - or "transfer" it [direct] from one database to anotheror Script the data in the tables (from SQL2008) |
 |
|
|
|
|
|
Backup database, ONLY tables