Wednesday, March 7, 2012

getting locking error when trying to copy database

Hi all...
I made a backup of our production database, and am trying to copy it over to
our test server.
About 3/4 into the way of the copy, I get an error message that reads:
cannot copy nmhsystem_013107: The process cannot access the file because
another process has locked a portion of the file.
I don't understand. This is a back-up... should I'd be clear of any
processes.
Any help would be appreciated!!!!!!!!!!!!
use filemon from sysinternals to see which process has opened a handle on
the file.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"pigfinn" <pigfinn@.discussions.microsoft.com> wrote in message
news:7CB383FA-AB1D-4B0A-9234-4686B791E3B6@.microsoft.com...
> Hi all...
> I made a backup of our production database, and am trying to copy it over
> to
> our test server.
> About 3/4 into the way of the copy, I get an error message that reads:
> cannot copy nmhsystem_013107: The process cannot access the file because
> another process has locked a portion of the file.
> I don't understand. This is a back-up... should I'd be clear of any
> processes.
> Any help would be appreciated!!!!!!!!!!!!
|||thank you!!, let me try to find out what filemon is
"Hilary Cotter" wrote:

> use filemon from sysinternals to see which process has opened a handle on
> the file.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "pigfinn" <pigfinn@.discussions.microsoft.com> wrote in message
> news:7CB383FA-AB1D-4B0A-9234-4686B791E3B6@.microsoft.com...
>
>

No comments:

Post a Comment