Dear all,
Can I backup a single table using file/filegroup backup?
If yes, please let me know the detailed steps.
Thanks,
Frankie.
by frankiex » Sun, 25 Aug 2002 10:50:57
Can I backup a single table using file/filegroup backup?
If yes, please let me know the detailed steps.
Thanks,
Frankie.
by Andrew J. Kell » Sun, 25 Aug 2002 07:30:24
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
Quote:> Dear all,
> Can I backup a single table using file/filegroup backup?
> If yes, please let me know the detailed steps.
> Thanks,
> Frankie.
by Russell Field » Sun, 25 Aug 2002 15:09:42
Russell Fields
Quote:> Dear all,
> Can I backup a single table using file/filegroup backup?
> If yes, please let me know the detailed steps.
> Thanks,
> Frankie.
1. Backup from filegroup without transaction log backups
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
backups?
Sent via Deja.com http://www.deja.com/
Before you buy.
3. JOB: Lead Database Software Engineer - Phoenix AZ
4. Backup a single table using SQL-DMO
5. Calling All Veteran SYBASE Users!
6. Single table restore from a file backup
7. Oracle and RDO Asynchronous Queries Timing Out
8. Differential File/FileGroup Backup
9. Filegroups (Using Backup and Restore to transfer data.)
10. backup - file and filegroup option disabled?
11. Full Database Restore Using FileGroup Backups
12. File/Filegroup Backup and Recovery