SQL Server Restore from Diff backup
We are taking Differential Backups every 6 hrs and putting it on the One of
the contengency server and we want to restore that differential backup once
a day. we have already applied the full back up as of today. Could someone
help me how to schedule the job to restore the differentiaal bakup? I tried
to restore it but it says use "RESTORE" or "NORESTOR" does the db should
be down. Do I have to have a script to run.
Any help is appreciated.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center