February 6, 2003 at 8:50 am
Is there anyway I can just back up certain tables in a database and not the whole database?
Ken
February 6, 2003 at 8:55 am
No.
You could DTS the tables to flat files, where the flat files will be your back.
Or you could DTS the tables to another database, and the other database could be your backup.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
February 11, 2003 at 2:07 pm
Well in fact yes. You could create more data files with new filegroups for the tables that you want to backup, and then backup the filegroup
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply