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 |
|
lluisdelta
Starting Member
9 Posts |
 Posted - 2009-07-31 : 15:15:04
|
| Hi,I have 2 SQL 2005 servers in mirrored mode (no witness). Is it possible to use the mirror server as a publisher? My goal is to have the whole database copied over to test and QA environments. Right now Im restoring daily backups from prod environment to those 2 machines (test and QA) but it's a lengthy process and wondering if there is a better, more efficient way to keep those 2 updated to the minute.Thanks in advance for your advice.edit: moved to correct forum |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-07-31 : 15:25:45
|
| I wouldn't setup Replication,Logshipping,Mirroring from Prod to QA,Test Environment. That is bad idea.You will be unneccesarily taxing Prod Server. Instead Write a SSIS Package that will get latest production backups and restore database in your enviroment and resync users. |
 |
|
|
lluisdelta
Starting Member
9 Posts |
Posted - 2009-08-03 : 18:49:01
|
| Thanks Sodeep. It makes sense. |
|
|
|
|
|
|
Replication using mirror server as the publisher