Link to home
Create AccountLog in
Avatar of Hersh
Hersh

asked on

How to restore differential full and backup

We are having following backup stategy
1. DATABASE FULL BACKUP  -  ONCE IN A DAY  - SAY  12.30 AM EVERYDAY
2. DIFFERENTIAL BACKUP       -   EVERY HOUR    -

HOW TO RESOTRE IT TO DIFFERENCE SERVER. GIVE ME FULL DETAIL STEP BY STEP. HOW TO RESTORE FROM FULL AND THEN DIFFERENTIAL
Avatar of VBClassicGuy
VBClassicGuy
Flag of United States of America image

See here for differential:
http://msdn.microsoft.com/en-us/library/ms175510.aspx
Here for a full:
http://msdn.microsoft.com/en-us/library/ms188312.aspx
Nose around the links at the bottom if you still have questions, or need to restore from something other than a device.
Avatar of Hersh
Hersh

ASKER

Can you please describe the restore in your steps
Don't have the time. But here is a link with FULL instructions, including pictures:
http://www.linglom.com/2008/01/12/how-to-backup-and-restore-database-on-microsoft-sql-server-2005/ 
ASKER CERTIFIED SOLUTION
Avatar of Hersh
Hersh

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account