November 16, 2005 at 8:25 am
I have a new vendor application that has 3 SQL databases. The client has expressed a need for a second SQL Server that will be used for a Disaster Recovery (DR) site. The vendor tells us we're 'on our own'.
I look at the database and see several things that may stop us using replication. Tables without Primary Keys, tables with text/image data, tables with identity columns etc...
Based on this I think my only option is to use log shipping. Does this sound right?
Thanks
November 16, 2005 at 9:26 am
log shipping sounds good. You need to use enterprise edtion of SQL server. Standard edtion does not support this.
November 16, 2005 at 6:59 pm
You can setup a manual version of SQL Server log shipping, even with Standard Edition. Perform tran log backup at production server, ftp or copy backup device to standby server, restore log. This all can be automated with sql jobs.
ChrisB MCDBA OCP MyDatabaseAdmin.com
Chris Becker bcsdata.net
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply