Restore Database from backup and applying all transaction logs backups performed from last full database backup

Question

Post reply

Restore Database from backup and applying all transaction logs backups performed from last full database backup

Welsh Corgi

SSC Guru

Points: 116520
More actions
January 8, 2016 at 10:33 am

#314845

How do you restore a database from backup and applying all transaction logs backups performed from last full database backup?
I would prefer a video, if not screen shots.
Thanks.
Edit: To include Point in time.
Do you backup the active Transaction Log if the problem existed during the last existing Transaction log backup or earlier?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 1

http://bfy.tw/3d5n

hope this helps.

Happy New Year Welsh.

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

J Livingston SQL (1/8/2016)
http://bfy.tw/3d5n
hope this helps.
Happy New Year Welsh.

Thanks for the link but I could not find what I was looking for.

Happy New Year.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I recall using SSMS and electing the Full Backup file, the latest differential and manually selecting all of the Transaction Log Backups.

I do not remember the steps that I took to accomplish it.

Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 4

Here's an article by Kathi Kellenberger[/url]. Here's one I wrote[/url]. Either or both should satisfy exactly what you're looking for.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Eirikur Eiriksson SSC Guru Points: 182881 More actions · Answer 5

Grant Fritchey (1/10/2016)
Here's an article by Kathi Kellenberger[/url]. Here's one I wrote[/url]. Either or both should satisfy exactly what you're looking for.

Grant, the link to your article doesn't work, copy paste error???

😎

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 6

Eirikur Eiriksson (1/10/2016)
Grant Fritchey (1/10/2016)
Here's an article by Kathi Kellenberger[/url]. Here's one I wrote[/url]. Either or both should satisfy exactly what you're looking for.
Grant, the link to your article doesn't work, copy paste error???
😎

Nah, looks like there's something wrong with the link. I can't reach it from my article listing either.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

dave.jones 96182 SSC Enthusiast Points: 116 More actions · Answer 7

--Restoring the full backup
RESTORE DATABASE TestDB
FROM DISK = 'E:\Backup\TestDBFull_1.bak'
WITH NORECOVERY, REPLACE

--Restoring log backups
RESTORE LOG TestDB
FROM DISK = 'E:\Backup\TestDBLog_1.trn'
WITH NORECOVERY

RESTORE LOG TestDB
FROM DISK = 'E:\Backup\TestDBLog_2.trn'
WITH NORECOVERY

RESTORE LOG TestDB
FROM DISK = 'E:\Backup\TestDBLog_3.trn'
WITH NORECOVERY

RESTORE LOG TestDB
FROM DISK = 'E:\Backup\TestDBLog_4.trn'
WITH RECOVERY

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 8

This is a year old thread. The articles I linked to show how to do exactly what the OP asked for.

Oh, and checked the link to my article. It works now for some reason.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning