Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kumar4700
Starting Member
2 Posts |
 Posted - 2009-12-02 : 10:07:25
|
| I am asked to test disaster recovery test-point in time recoveryWe have one production server(3 user databases), application users will connect to database via websites.And recently took another server (DR server). Do I need to set up logshipping for disaster recovery or just restore all databases in DR server and route the application users . Please let me know the steps . Kind of new to SQL Server. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kumar4700
Starting Member
2 Posts |
Posted - 2009-12-02 : 13:27:55
|
| Thanks for your reply.We have SQL Server 2005 std edition, can we use database mirroring. If so what service pack do we need to have?How many servers we need to have for db mirroring, we don't want to loose any data |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-12-02 : 13:53:22
|
| Database mirroring is available in standard edition. You should install service pack 3 since it has been around for quite a while and contains numerous bug fixes for previous builds.You need a minimum of two SQL Server instances. We only use two. We do not use a witness. We use asynchronous database mirroring due to the performance lag of a two-phase commit on synchronous mirroring.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
johnboyd
Starting Member
9 Posts |
Posted - 2009-12-13 : 11:17:03
|
quote:
Originally posted by tkizer
Database mirroring is available in standard edition. You should install service pack 3 since it has been around for quite a while and contains numerous bug fixes for previous builds.You need a minimum of two SQL Server instances. We only use two. We do not use a witness. We use asynchronous database mirroring due to the performance lag of a two-phase commit on synchronous mirroring.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
In real disaster, how much data you lose in Asynchronous mirroring? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
DR test