November 2, 2012 at 4:33 am
Scenario:
I have Databases which are backed up every night (Full Backup); the Backups are saved on a Tape then deleted from the Sever after three days.
1.The Backups are taken at 8pm the previous day and if something goes wrong, for example at 4ppm the next day I would have to Restore the last Backup then rerestorell the Log files since the last Backup (The Log Backups are done every 15 minutes), imagining the Database will need to be Back online as soon as possible; the procedure will take a very long time.
I wanted to know if there is a better way of performing a Disaster Recovery other than the following Procedure:
RESTORE DATABASE DB_TestLSN_Restore
FROM DISK = 'c:\Backup\DB_TestLSN.bak'
WITH MOVE 'DB_TestLSN' TO 'E:\MSSQL\DATADB_TestLSN_Restore.mdf',
MOVE 'DB_TestLSN_log' TO 'F:\MSSQL\LOG\DB_TestLSN_log_Restore.ldf',
NORECOVERY, NOUNLOAD, STATS = 10
GO
RESTORE LOG DB_TestLSN_Restore
FROM DISK = N'C:\Backup\DB_TestLSN_LOG1'
WITH NORECOVERY, NOUNLOAD, STATS = 10
GO
RESTORE LOG DB_TestLSN_Restore
FROM DISK = N'C:\Backup\DB_TestLSN_LOG2'
WITH RECOVERY, NOUNLOAD, STATS = 10
GO
And so on until the last log is Restored.
2. Is there a way, if possible just to restore a single table if for example something gets deleted or if the table becomes corrupted?
Thank you in advance!
November 2, 2012 at 4:52 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1380263-384-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply