Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Database Restore Expand / Collapse
Author
Message
Posted Wednesday, February 5, 2014 4:55 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:59 AM
Points: 17,822, Visits: 15,747
homebrew01 (2/5/2014)
If you took the backups using native SQL, and they are stored in the same location as the time of backup, then I think you can use the GUI to restore and it will show you all the t-log backups, already selected, ready for the restore.

It might be a good idea to go through the procedure with a test database so you are familiar with the steps,


Yes, that is a nice feature added to 2012 and 2014.

And re-emphasize the testing of the restore process.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1538411
Posted Wednesday, February 5, 2014 5:04 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:29 AM
Points: 2,832, Visits: 8,511
Earlier versions have it too.


Post #1538415
Posted Wednesday, February 5, 2014 5:18 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:59 AM
Points: 17,822, Visits: 15,747
That feature disappeared with SQL 2005. You can get something like it if you have all of your backups in the same backup file or in the same backup device. But that is different than how 2012 now works where it reads the backup history.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1538419
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse