Solved

Copy constantly locked files over network?

Posted on 2011-02-23
5
1,442 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Office 365 Training for IT Pros

Learn how to provision Office 365 tenants, synchronize your on-premise Active Directory, and implement Single Sign-On.

Question has a verified solution.

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

A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
A hard and fast method for reducing Active Directory Administrators members.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

738 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