Can I backup a single table using file/filegroup backup?
If yes, please let me know the detailed steps.
Andrew J. Kelly, SQL Server MVP
Quote:> Dear all,
> Can I backup a single table using file/filegroup backup?
> If yes, please let me know the detailed steps.
I have a mssql 7.0 database of 2 GB (it will probably grow to 5 GB). In
this database I have approximately 130 tables. Every night I make a
full backup. Sometimes I get called that the data updated in an table
over the last month is totally wrong. The table needs to be recovered
to the state it was in the previous month.
In mssql 6.5 I restored just that one table. In mssql 7.0 this is not
possible any more. The server is not big enough to contain 2 databases
of 5 GB.
I have the following solution. I know which tables can cause problems.
I want to put these tables on there own file group. If I have to
restore a table I restore that filegroup. However I dont have the
transaction log backups from the previous month.
Question will the database be consistent without the transaction log
Sent via Deja.com http://www.deja.com/
Before you buy.