March 9, 2010 at 10:16 pm
Dear All,
Takan a db backup in sql develpoer edition 20005 (Windows xp)
Receiving follwoing error:
msg 3202:
The process cannot access the file because another process has locked a portion of the file.
Query used:
backup database to disk='d:\cb.bak' with init
Pl let me know how to fix this.
Gugan..
March 9, 2010 at 10:27 pm
Check if any other process are running.
http://www.sqlservercentral.com/Forums/Topic157874-24-1.aspx
March 11, 2010 at 7:53 am
Use Sp_who2 and sp_lock to find out spid which are creating problems
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 4:55 am
Usually when I get this error, another backup is actually running at the time. But it's only happened to me maybe two times, so "usually" might not mean anything.
March 18, 2010 at 6:02 am
I've had it happen when the nightly tape backup overlaps with the sql full, or log backup, so also check this process.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply