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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ehab SalemIT ManagerCommented:
I do not think this is possible.
Brian PiercePhotographerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Guy Hengel [angelIII / a3]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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.