April 23, 2010 at 11:36 am
Ok, so this weekend is the big cutover from our physical SQL 2005 32-bit database to a new SQL 2005 64-bit VM.
I have been asked if I can setup replication to get those 2 servers identical in case we need to fall back to the physical vs. the VM.
Can this be done? I mean, can I setup a SQL 2005 64-bit VM as the publisher and the SQL 2005 32-bit physical as a subscriber?
April 26, 2010 at 12:20 am
Underneath the wrapper, replication uses T-SQL to do its work. There is no particular restriction imposed by 32 bit Vs 64 bit so you should be OK
April 26, 2010 at 3:14 am
Timothy.Cloud (4/23/2010)
I have been asked if I can setup replication to get those 2 servers identical in case we need to fall back to the physical vs. the VM.Can this be done?
This can be done.
However, please note replication is not a HA (High Availability) solution.
You can consider other HA solutions such as Log Shipping, Mirroring, etc.
April 26, 2010 at 3:53 am
Suresh B. (4/26/2010)
Timothy.Cloud (4/23/2010)
I have been asked if I can setup replication to get those 2 servers identical in case we need to fall back to the physical vs. the VM.Can this be done?
This can be done.
However, please note replication is not a HA (High Availability) solution.
You can consider other HA solutions such as Log Shipping, Mirroring, etc.
Agree!
In your case mirroring would be a much better solution and offers greater reliability, ease to setup, HA and control options.
There are now bit-level restrictions (only that you must have at least standard edition). However: you must initiate the mirror while the db is under low usage (as you need to restore backups and logs to the mirror server and wouldnt want the active log growing too much during this time).
HTH 😀
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply