InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:57:39 GMT20http://www.sqlservercentral.com/Forums/Topic9165-5-1.aspxThis happened to me running SQL2000 under VMWare, running a backup with RedGate HyperBac 5.7.0.155 as the transparent compression. The backup had hung (which has happened twice on this, our only virtual SQL Server) and when I restarted MSSQLServer, Hyperbac still had a lock on master.mdf. I had to kill Hyperbac thru taskmgr (its UI didn't kill it) and then was able to restart MSSQL.Tue, 09 Oct 2012 19:12:57 GMTGary Neasehttp://www.sqlservercentral.com/Forums/Topic9165-5-1.aspxIt may be a fluke that just occurred but check in Event Viewer and SQL Server Logs to see if any other specific event occurred around the time the problem started. Also, check job histories to see if any may have reported an issue or ran extremely long during the time of the condition. Wed, 08 Jan 2003 14:45:00 GMTAntares686http://www.sqlservercentral.com/Forums/Topic9165-5-1.aspxThanks lot, Antares686. Yes after I restarted MSSQLServer and SQLAgent, the lock went away. I have backup job running nightly to backup system databases, including Master. But I've running the job forever and never had such problem. The only change that we made recently is upgrade from SQL7 to SQL2k, but we have been running our app on it without any issues till yesterday.Thanks. Wed, 08 Jan 2003 14:27:00 GMTSdudehttp://www.sqlservercentral.com/Forums/Topic9165-5-1.aspxFirst have you tried restarting the service and the server to see if the issue goes away? In addition are there any other processes that could be hung such as a backup running against master currently? Wed, 08 Jan 2003 10:17:00 GMTAntares686http://www.sqlservercentral.com/Forums/Topic9165-5-1.aspxHi everyone , please help!!!Since yesterday, our SQL started to thowing out this error:Event Type: ErrorEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 17055Date: 1/8/2003Time: 09:31:05User: N/AComputer: SQLserverDescription:17113 :initconfig: Error 32(The process cannot access the file because it is beingused by another process.) opening 'e:\MSSQL\data\master.mdf' forconfiguration information.Data:0000: d9 42 00 00 10 00 00 00 ÙB......0008: 0c 00 00 00 4d 00 49 00 ....M.I.0010: 54 00 53 00 45 00 52 00 T.S.E.R.0018: 56 00 45 00 52 00 30 00 V.E.R.0.0020: 36 00 00 00 00 00 00 00 6.......When this happened, none of my applications can access the SQL server andlock up the users that are trying to run the app. I searched Technet andseveral news groups on the net, and they all pointed me to the issues withUser Connections settings. However, our server uses the default settingswhich allows unlimited connections. I' lost where I should start to fixthis. Has anyone run into this error, and how have you fixed it?Any help will be greatly appreciated.Daniel. Wed, 08 Jan 2003 09:53:00 GMTSdude