August 19, 2009 at 8:27 am
Hello Everyone,
I am going to upgrade our production servers to SQL 2008 Server from SQL 2000. We have couple of Web Servers are using Web Application with SQL 2000 at the moment. I want to setup as the Mirror Server for some Databases.
To be honest, I never setup the Mirror Server before and I am bit worry about recovery issue if one of the server is failed.
I found the website which explains about how to setup the mirror server, please see below -
is that good website to look at or other website can explain more about setup the Mirror Server?
My questions are -
1. Any advantages and Disadvantages about Mirror Servers
2. How to restore the databases if Principle Server is Failed. What kind of steps I need to follow to up working everything again?
3. What if Mirror Server is failed, do I need to setup everything up again?
4. Which Database I need to backup? Principal Server or Mirror Server?
5. How to switch web config to look at Mirror Server if Principle Server is failed? Do I need to change manually in Web Config to look at mirror server?
6. If I need to move one of the principal/mirror server to another machine, how to transfer to another machine without taking website Offline?
I would like to get all documented so that everything are in same place about MIRROR SERVER if me or whoever (new learner like me) need to look at it again in the future.
Thanks.
Leo
August 19, 2009 at 8:59 am
Have you read through all the material in Books Online?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 19, 2009 at 9:05 am
Most of these are answered in Books Online.
To get the web server to move, you'd need to change the web.config unless you have the new SNAC client. In that case, you can specify two servers in your connection string.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply