Setting up DoubleTake to replicate mdf and ldf file for sql server - first time
Posted on 2008-10-13
I am setting up doubletake for the first time. I create a test database on a sql server A. I backed up that database and restored it on sql server B. I created a replication set to replicate that mdf and ldf file from sql server A to sql server B. However, after the mirroring starts it errors out saying to "close the file that is in use on the target". So, I detached that database on server B and started back mirroring and the errors go away.
Can I not have that database attached on Server B while mirroring is happening???? I need it attached. Can someone lead me in the right direction with this?