Solved

Copy constantly locked files over network?

Posted on 2011-02-23
5
1,438 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:John86a
  • 3
5 Comments
 
LVL 22

Expert Comment

by:Joseph Moody
ID: 34961544
Check out volume shadow services. You can copy/backup in use files.
0
 
LVL 9

Expert Comment

by:davealford
ID: 34961551
backup with NTbackup and use shadow copy?
0
 

Author Comment

by:John86a
ID: 34961659
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
 

Accepted Solution

by:
John86a earned 0 total points
ID: 34984284
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
 

Author Closing Comment

by:John86a
ID: 35015588
I should start answering questions.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SCCM Active Directory Audit functions 2 26
Activity directory migration 4 22
SSL-VPN 1 43
How to change subnet mask for Fortigate WAN interface 2 29
I had an issue with InstallShield not being able to use Computer Browser service on Windows Server 2012. Here is the solution I found.
A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question