March 17, 2009 at 6:48 am
My department is planning on setting up an imitation SQL Server 2005 clustered environment with one active server and an older server acting as the passive server**. We are going to have a Lun attached to the main server that holds the Log and DB files. If something catastrophic were to happen and we are unable to detach our databases cleanly, would it be possible for us to reattach the databases to the passive server?
**We were hoping to push the department to set up an actual cluster environment, but due to financial setbacks and the risk of downtime, we are unable to pursue this avenue.
March 18, 2009 at 3:56 am
Not sure what you are asking. If you have a cluster the shared disk will automatically switch to the standby server. If the standby server is not available and neither is the primary server then the database files on the shared disk can be attached to another server if necessary. Are you getting a cluster or just two separate servers?
March 18, 2009 at 6:03 am
We are going to have 2 separate servers. One server that will do nothing other than be a backup for the active server if something where to happen.
March 18, 2009 at 6:45 am
In that case in the event of the active server going down you can point the passive server to the disks containing the data. Have you considered mirroring?
March 18, 2009 at 7:18 am
Thank you for your reply.
Yes, we have considered mirroring, but I've been told that we have too many databases to consider mirroring (we have about 20 dbs and counting). Is that too many, or was I misinformed?
March 18, 2009 at 8:18 am
There are no fixed limits on mirroring, it depends on your network and the activity on the databases. A general recommendation is around the 10-20 database mark but it can be monitored to see how it is going.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply