Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Copy constantly locked files over network?

Posted on 2011-02-23
5
Medium Priority
?
1,479 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

618 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