December 11, 2002 at 8:07 am
I recently went over a disaster recovery plan with a vendor and they recommended using log shipping to an off-site server. I have never used this before and I was wondering if there was any do's or don'ts anyone can share with me. Are the transaction logs the only info that would get shipped to the offsite in most cases? I would be concerned abuot how I would transfer a full db backup over a slow line a few months down the line. Any best practices would be greatly appreciated. Thanks!
December 11, 2002 at 10:36 am
Log shipping is not a real-time operation. You can accomplish the same thing with less trouble by performing regular backups and send those offsite. Unless you're dealing with financial data that can't suffer any loss, this approach works well.
December 11, 2002 at 11:22 am
I need to have it as update to date as possible on the offsite so thats why the log shipping was recommended because you are sending over logs for example every 5 minutes. It might not be real time but from a cost effective stand point, we have this server clustered and moving real time in house for backup but the concern is say we lose the whole floor. We need to have this offsite as real as possible.
December 12, 2002 at 2:51 am
To use Log shipping out of the box you need enterprise edition. However ther are scripts available that will do it for you, I recently wrote a set for a client and its not too hard.
The big issue is the shipping of the first backup, you also then need to know how big you logs are going to be. To calculate the transfer time, it may be that you can't transfer the file quick enough.
You also need to decide if the data is to be maintained read only on the standby server. This allows you to read the data but not edit it even if you haven't recovered the server.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
December 12, 2002 at 2:56 am
Using SQL Lite Speed will be good for log shipping as the files are compressed by about 90%
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply