Saturday, February 25, 2012

Operating conditions after mirroring.

Are there any restrictions in the restored database after database mirroring?

I mean, Is it full mirror of my primary database?

What I want to do:

If my machine A(with primary database) will down I will redirect my clients to a real-time copied database - mirror server. I don't want to create cluster, but I want to use database mirroring function in ms sql 2005.

Can I use DB Mirroring to solve my problem?

p.s. sorry for my english Smile

Yes that is exactly what mirroring is for. The mirror database is an exact copy of the principal.

No comments:

Post a Comment