sql server 2005 mirroring

5 pts.
Tags:
Server mirroring
SQL Server
SQL Server 2005
SQL Server backup
i have 2 servers, with sql server 2005 standar version, running mirroring, can i see if the data is being updated? how know that? can i make backups while running my mirroring?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can certainly run backups of the Primary node of the mirror and do them online just like a server that is not being mirrored. As far as the backups are concerned they do not care if you are mirroring. I would recommend backing your DBs up and do not rely on the mirror as your backup. As far as checking if Mirroring is working MS has a tool that will do this for you. Just goto your SQL Server Management Studio and connect to the instance. Once connected expand the databases tab. Once that opens you should see the name of the miroed DB and it should say Principal and whether or not it is synchronized or disconnected. Then right click on the Database and go to tasks then to Launch Database Mirroring Monitor. This will have you register the server and will show you the Mirror and show you the data transfer between the servers.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following