July 1, 2006 at 9:50 am
What is the best way to back up sql server to a remote site so that if we had total data loss locally I would be able to restore and get back up and running as quickly as possible. I have a remote file storage option that I use and I currently store a MSAccess version of the db there. I assume there is a much better solution to this. Can someone "upgrade my knowledge" please?
Thanks a ton~
July 1, 2006 at 8:46 pm
Personally I'd recommend using log shipping. Take a full copy of the database, restore it to your remote location but do not recover the database (WITH NORECOVERY or the second or third radio button in the options page in the GUI). The periodically take backups of the transaction log (make sure you're in Full recovery mode), copy them to the remote location, and restore it without recovery. Continue with that ad infinitum.
This does assume that you have SQL Server installed on your remote location. If you don't, you'll need to simply copy the backup over to the remote location on a regular basis. I'd back up first to the local server, then have a separate job step to copy it to the network location.
Hope that helps a bit.
July 1, 2006 at 9:07 pm
I do not have SQL Server installed at the remote location so I will follow your second suggestion, which is the one that I was guessing was the way to go.
Thank You~
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply