Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 659
  • Last Modified:

Setting up DoubleTake to replicate mdf and ldf file for sql server - first time

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?
0
jwa082276
Asked:
jwa082276
  • 3
  • 3
  • 2
1 Solution
 
jorge_torizResearch & Development ManagerCommented:
Well, while you use mirroring the database must be "restoring..."... all you can do to read it is create a snapshot
0
 
jwa082276Author Commented:
so should I use "replication" and not mirroring? will this allow me to have the database attached?
0
 
jorge_torizResearch & Development ManagerCommented:
Well, what do you want to get?

To split your work between servers you must use replication, to have a backup server you must use mirroring
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
jwa082276Author Commented:
This is what I am trying to accomplish.....
I have to a nightly refresh of a database on server B which is in a differnt location than server A. the size of the database is too large to copy over the network so I was thinking doubletake to replicate the data from the db on server A to a db on server B so that on a nightly basis I can take a backup locaally on server B and do my refresh.  I can NOT use sql replication because of the appilcation restrictions.  I was hoping the db on server B could still be attached so that at night I can just schedule a job to do a nightly backup.

Understand what I am trying to accomplish?
0
 
jorge_torizResearch & Development ManagerCommented:
Ups, not so clear.

On server B you have a database that receives a nightly refresh... must this database be replicated on server A?
0
 
TalonNYCCommented:
DUE DISCLOSURE: I work for Double-Take =)
Due to the way we replicate, you won't be able to mount the DB on Server B.  You can, however, back up the MDF and LDF files as flat files from Server B while the replication is going on.  We'll play nice with the backup tools.

Hope this helps.
0
 
jwa082276Author Commented:
What backup tool would you sugguest we use?
0
 
TalonNYCCommented:
DUE DISCLOSURE: I work for Double-Take

We currently have tested with most major vendor's tools (NetBackup, Backup Exec, ArcServ, etc) and therefore you can use anything from NTBackup to one of the more advanced tape or disk tools.

The good news is that you won't need the SQL-specific agents, the bad news is that it will basically be a file-level backup, not a SQL-specific backup.  You could do a SQL backup off the production box, but the Target would be file-level only.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now