SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Restoring Backup with T -log
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

poratips
Posting Yak Master

105 Posts

Posted - 05/22/2013 :  00:00:00  Show Profile  Reply with Quote
Hi,
I will be doing first time restore from Full backup, Differential and Transaction Log back up, what will be the ideal procedure I have to follow?
We are taking weekly Full backup, Daily Differential and every hour T-Log back up into Sql server 2008.

Thanks,

chadmat
The Chadinator

USA
1974 Posts

Posted - 05/22/2013 :  03:28:21  Show Profile  Visit chadmat's Homepage  Reply with Quote
Restore latest Full, Latest Diff (Prior to the point in time you want to restore to), then every TLog backup after that Diff, up to the point in time you want to restore to.

-Chad
Go to Top of Page

poratips
Posting Yak Master

105 Posts

Posted - 05/27/2013 :  16:49:51  Show Profile  Reply with Quote
Thanks Chad.
So If I want to Restore up to Wednesday 11 AM then Full back up from Weekend, Tuesday night's Differential back up and after differential back up time, all the TLog back up to 11 AM, Right?
We normally taking back up - Full Back up weekend, Every night Diff Back up and Every hour T -Log back up
Go to Top of Page

ksr39
Posting Yak Master

India
188 Posts

Posted - 05/27/2013 :  23:15:18  Show Profile  Reply with Quote
Yeah thats correct but you need to restore the full, diff backup's with no recovery and all the t-logs last but one with no-recovery and the last with recovery then your database is back as you were expecting.

Thank You All In Advance
KRS39
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2079 Posts

Posted - 05/28/2013 :  01:31:57  Show Profile  Visit jackv's Homepage  Reply with Quote
Use the backupset and backupmediafamily tables in msdb to view the backup history of the database. That way you can request the relevant files fro restore
http://www.sqlserver-dba.com/2012/06/display-sql-backup-history-for-a-single-database.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

poratips
Posting Yak Master

105 Posts

Posted - 06/17/2013 :  00:23:18  Show Profile  Reply with Quote
Thanks KRS.
You mean:

1)Restore the full and diff backup's with NO RECOVERY
2) All the T-Logs with no-recovery except the last T-Log which will be with recovery , Right?

Thanks
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2079 Posts

Posted - 06/18/2013 :  15:21:18  Show Profile  Visit jackv's Homepage  Reply with Quote
That's the way to do it - only with recovery on the last log file

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000