SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 05:08 PM
| ||||
| ||||
 Replication v Log Shipping Ok situation is like so; I run a website from a SQL2k cluster. However, I wish to replace the entire hardware set up (array and everything). I wish to keep the down time to an absolute minimum. Therefore I'm considering installing the new cluster alongside the old one and setting it as a warm stand-by. What whould be best for this? Log Shipping or transactional replication? I'm thinking Log Shipping will be cleaner. Basically, I want to be able to stop the website, carry across the last logs and then have the databases on the new server, exactly the same as those on the old. I will then set the new cluster as the live db. That will be the end of the replication/log shipping it's simply to get the new hardware live. Does anyone have any comments on the pros/cons of this approach and which is likely to be better? Log Shipping or replication? Many thanks J      |
|
02-27-2008, 05:08 PM
| ||||
| ||||
| Re: Replication v Log Shipping If I wanted to move the database, instead of formal log shipping, I would simply backup the orig then restore it on the new.... when that was done, I'd make sure all the logins and users matched correctly... then stop the prod, backup its log , and manually restore it.... "Julie G" <Julienoemail@hotmail.com> wrote in message news:#jmLbnKYDHA.1644@TK2MSFTNGP10.phx.gbl... > Ok situation is like so; > I run a website from a SQL2k cluster. However, I wish to replace the entire > hardware set up (array and everything). I wish to keep the down time to an > absolute minimum. Therefore I'm considering installing the new cluster > alongside the old one and setting it as a warm stand-by. What whould be best > for this? Log Shipping or transactional replication? I'm thinking Log > Shipping will be cleaner. Basically, I want to be able to stop the website, > carry across the last logs and then have the databases on the new server, > exactly the same as those on the old. I will then set the new cluster as the > live db. That will be the end of the replication/log shipping it's simply to > get the new hardware live. > Does anyone have any comments on the pros/cons of this approach and which is > likely to be better? Log Shipping or replication? > > Many thanks > J > > > |
Linear Mode
