November 12, 2002 at 1:18 pm
Hi everyone, I need to backup all tables in a database. Is it possible to only backup the tables?
If I backup the data file(group) and restore it to another database, would that restore the tables along with the data? Are there any other "side-effects" to this approach? Thank you.
November 12, 2002 at 2:07 pm
When you backup a database it backs up everything (Tables (schema and data), views, stored procedures, users, etc).
If you restore a backup onto another database it will restore everything (tables, views, stored prodedures, users, etc).
Side effects, are when you restore a database on to another server you will most like end up with orphan users.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 12, 2002 at 2:25 pm
But I don't want to back up everything. I only want the tables.
I have another question, if I back up everything (full backup) and restore to another database, will the restore remove the tables that are already in the new database? For example, if the new database has table A and the restore is going to restore table b and some procedures, will table A still be in that database after the restore is finished?
Thanks.
November 12, 2002 at 2:26 pm
If you want to backup only tables, then create the tables on a Filegroup. Then backup the Filegroup.
- good for a large size table.
If want just the table schema then script it out.
Could also use DTS here depending on exactly what you want to accomplish.
November 12, 2002 at 2:28 pm
If you restore a database it will overlay everything in an existing database. In your example table A will be gone.
If all you really want to do is migrate tables, maybe DTS is really the tools you should use.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 12, 2002 at 2:30 pm
If you restore over an existing database, what will remain is exactly whats in the backup you are using.
Everything will be overwritten.
November 13, 2002 at 3:57 am
Use DTS. This is easiest with the export or import function on the right-shift menu.
It has enough options for most purposes.
November 13, 2002 at 9:09 am
Hi ,
You were able to backup the tables only in SQl server 6.5 version.But after 6.5 version you cann't backup only the tables.If you want to do that as meantioned by some one you have to keep all the tables on a different filegroup and do a file group backup.
November 13, 2002 at 4:43 pm
Thank you for your help everyone.
I have one more question. Lets say I have all of my tables on one filegroup and I back that filegroup and restore it to another database. Will I loose any of the views and scripts on that database or will the restore only replace the tables in that database?
Thanks again.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply