January 3, 2008 at 8:22 am
I want to verify that I can set up database mirroring and log shipping from a 64-bit SQL Enterprise Cluster to 2 different 32-bit SQL 2005 servers. The mirroring will be set up for a one-time move of the database, and log shipping will be set up temporarily for a reporting database. I wouldn't think there would be a difference with the databases, but can't find any documentation to confirm. Has anyone done this or know of any articles addressing this? Thanks.
January 3, 2008 at 8:30 am
Not sure about the 64-bit to 32-bit move. Both of these require a full backup and you can easily test that to see if it works.
If you are doing reporting off the Log Shipping database, be aware that each time to do a restore of a new log, no users can be in the database, which means they'll be kicked out and can't connect while the restore is taking place. If you restore every 5 minutes, this can be an issue.
January 3, 2008 at 8:38 am
Yes, I am very familiar with log shipping and have tested mirroring a number of times, but thanks for the reminder 🙂 Since both are initially set up with a database backup, I still think it would be ok because you are still restoring a SQL 2005 backup. Maybe I should look for articles regarding a restore from a 64-bit system to a 32-bit system. Thanks.
January 3, 2008 at 2:12 pm
On the database mirroring, as long as you are running the same edition on both ends (e.g. std to std or ent to ent), you are fine and 32-bit to 64-bit shouldn't be an issue. In terms of log shipping, as the SQL Server on-disk storage format is identical between 64-bit and 32-bit builds, this will not be a problem.
Thanks,
Phillip Cox
January 3, 2008 at 2:16 pm
That's what I thought as well but wasn't sure. I may get the opportunity to run a few tests to confirm. Thank you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply