Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
tommypa
Starting Member
19 Posts |
Posted - 2008-03-20 : 12:27:13
|
Good afternoon!My name is Tommy and wanted to introduce myself, I am new to the forum and I have an issue that hopefully someone can assist me with. I am attempting to do a restore of a database and I am getting the following error. Event Type: ErrorEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 3634Date: 3/20/2008Time: 11:57:54 AMUser: N/AComputer: COLSQL01Description:The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'I:\MikeD\20070430-COLDAT'.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Data:0000: 32 0e 00 00 10 00 00 00 2.......0008: 09 00 00 00 43 00 4f 00 ....C.O.0010: 4c 00 53 00 51 00 4c 00 L.S.Q.L.0018: 30 00 31 00 00 00 07 00 0.1.....0020: 00 00 6d 00 61 00 73 00 ..m.a.s.0028: 74 00 65 00 72 00 00 00 t.e.r...Does anyone have any ideas?any feedback is always appreciated.Tommy |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-20 : 13:35:10
|
Since something else is using the file already, you'll need to either kill that other process or reboot the box. Do you have a Kill program?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|