Restore from transaction log backups
-
I am new to SQL Server. I need to restore a database from a full backup and successive three transaction log backups.
All backups are located in a folder. There are four backup file , one for full backup and three for transaction log backups. No backup devices.
Honestly, this stage I am strugling to restore from all these files. Could anyone please suggest me or provide me a T-SQL statements how we restore database in such case..please
-
Hi Maddy,
Perform the following steps,
Restore database DBname from disk = 'Full path of ur full backup" with NoRecovery
Restore log DBname from disk = 'Full path of ur 1st tran log backup" with NoRecovery
Restore log DBname from disk = 'Full path of ur 2nd tran log backup" with NoRecovery
Restore log DBname from disk = 'Full path of ur 3rd tran log backup" with Recovery
if the db u restore already exist u need to overwrite the same.....refer,
http://technet.microsoft.com/en-us/library/ms186858.aspx
http://msdn2.microsoft.com/en-us/library/ms177429.aspx
http://msdn2.microsoft.com/en-us/library/ms177446.aspx
[font="Verdana"]- Deepak[/font]
-
Restore the full database backup with norecovery mode. Then restore the first and second transaction log with the norecovery clause and atlast restore the last transactional backup file with recovery mode and your database will be up and ready to use.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
If this is a point in time and you are going to use an existing DB, the FIRST STEP is to backup the "CURRENT" transaction log ( so called tail backup
)
* Noel -
I don't think so he is doing a point in restoration. But still this would help if he does.
the last restoration with the recover clause should have the STOP AT option to do a point in time recovery.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply