Robocopy and Live SQL database


Anyone use Robocopy for delayed (say 2 hour) live backup of live SQL database (Mimer SQL). I'm sure it can be done but how do you force copy some of the database files if they are locked?

I want to mirror our server at a co-location..well currently am but not the won't copy the open files.

Any suggestions would be much appreciated
Who is Participating?
KCTSConnect With a Mentor Commented:
Robocopy cannot backup open files - as you have found out.
2 options -
1. Get the SQL administrator to do a backup from within SQL (the preferred option)
2. Use a utility that can deal with open files eg Windows Backup or the paid for version of SyncBack
Ehab SalemIT ManagerCommented:
I do not think this is possible.
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
I agree with above.

you have to backup the database online to disk (with T-SQL BACKUP statement, and then you can use robocopy to copy that backup file elsewhere.

if you really wanted to copy the .mdf and .ldf files, you have to detach the database (or fully stop sql server).
stuartpedenAuthor Commented:
<KCTS and angellll>
Please excuse my SQL ignorance! ;)
There is no SQL Admin and the support for the Mimer SQL is crap.
So I'm dealing with Mimer SQL which is a bit different.
What I actually want to achieve is to have a backup of the database every couple of hours to a remote location without interupting users of same database. I am OK with not copying the data live but need reliable hourly/2 hourly redundancy, so are you saying this is possible with a T-SQL Backup statement or Syncback?
I can't say I'd be happy using any windows backup.
A backup with Mimer SQL means stopping the database server and means interupting operations. I do this nightly but I'm looking for some more redundancy.
How robust is Syncback, especially with database?
I know nothing of T-SQL Backup Statement or how I would use this with Mimer SQL?
What I do know is that it's really easy to wreck tables etc in Mimer.
</KCTS and angellll>
stuartpedenAuthor Commented:
It would be nice to know answers to the secondary questions I asked.
All Courses

From novice to tech pro — start learning today.