CODEWITHSUNDEEP
sql-serversql-server-express
user1096112
user1096112

Reputation: 107

SQL Express database mirroring

I have 2 Microsoft SQL Express 2008 database servers (A & B), but only 1 is used at a time.

In case something happends with database server A i take the latest backup from A and restores server B from that backup, and then i run B as the active database server

In this scenario: what would be the best way to keep B up to date at all times instead of using restore from backup? Is there any smooth way to keep both databases mirrors of each other in real time?

Thanks!

Upvotes: 1

Views: 7473

Answers (2)

NYdmX
NYdmX

Reputation: 1

I know this is an old post, but maybe this will help someone else in future search for help. Your allowed to install another instance of SQL using your existing license number as long as your only using the sever as a mirror. When you bring principal back online after a failover make sure same rules apply. In other words if you have 5 databases running on principal and it goes down and you fail over one to the mirror , then when the principal comes back on line you can't have the other 4 running on primary and the mirrored db running on mirror server.

Upvotes: 0

veljasije
veljasije

Reputation: 7102

Since Database Mirroring and Log Shipping is not available in SQL Express editions, here is one workaround to set up log shipping ins Express edition.

Log Shipping in SQL Express

Upvotes: 2

Related Questions