Solved

Copy constantly locked files over network?

Posted on 2011-02-23
5
1,404 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

Join & Write a Comment

Resolve DNS query failed errors for Exchange
When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now