Copy constantly locked files over network?

My question is plain and simple, I need to copy the .mdf file of SQL server while it is are running - via network. A quick copy paste says it's not possible because the file is in use. Hobocopy doesn't work via network - I know about the backup database, but at the moment I have no access to the SQL server and I just want to backup the whole database in run time. I have administrative privileges on all the machines present on the domain, including the one I'm trying to copy the file from.

How can I proceed?
John86aAsked:
Who is Participating?
 
John86aConnect With a Mentor Author Commented:
I found a tool for myself. It's called PsTools, free and provided by microsoft.
What it does is that it allows me to control practically everything on a remote machine without needing to install anything.

0) I copied Hobocopy over to the \\machine I needed stuff from that was locked.
1) Downloaded pstools from http://technet.microsoft.com/en-us/sysinternals/bb896649
2) Extracted on the local machine
3) Start -> run -> typed cmd
4) On cmd I browsed to the location I extracted pstools
5) Once there I typed: psexec \\machine\ cmd
6) It then opened the DOS prompt of that \\machine without asking for password (since I'm domain admin)
7) I browsed to hobocopy location, typed hobocopy C:\SourceOfTheLockedFile\ C:\Destination LockedFile.ext
8) Then I went back on local windows, browsed on the folder \\machine\c$\Destination and voilá, there was my file.

THIS IS HOW YOU COPY LOCKED FILES OVER THE NETWORK IF YOU ARE ADMIN.

Thanks for trying.
0
 
Joseph MoodyBlogger and wearer of all hats.Commented:
Check out volume shadow services. You can copy/backup in use files.
0
 
davealfordIt SupportCommented:
backup with NTbackup and use shadow copy?
0
 
John86aAuthor Commented:
Dave, can you please give me an example of usage of NTBackup? I.e. how would I copy file X.mdf located at \\SQLServer-001\SQL\X.mdf to local drive C:\ ?
0
 
John86aAuthor Commented:
I should start answering questions.
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.

All Courses

From novice to tech pro — start learning today.