tag:blogger.com,1999:blog-7334907730481072936.post4777365586514044613..comments2024-03-08T00:16:50.328-08:00Comments on SQL Server Expert: How to move TempDB in SQLServer?Satishbabu Gunukulahttp://www.blogger.com/profile/02630966486825083489noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7334907730481072936.post-54969098369643152972012-03-15T16:16:22.881-07:002012-03-15T16:16:22.881-07:00First check that any AV software running on ther s...First check that any AV software running on ther server. If anything running the exclude the above disk location. Also check that any backup is running or in hang state.<br /><br />Use processes explorer to find the processes opened or loaded the files.<br /><br />1. Download processes explorer from http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx <br />2. click on Find menu and choose DLL or file handle<br />3. Type the file name and click the search button<br /><br />You should see the list of apps accessing the file.<br /><br />Hope this helps,Satishbabu Gunukulahttps://www.blogger.com/profile/02630966486825083489noreply@blogger.comtag:blogger.com,1999:blog-7334907730481072936.post-81124558979204976772012-03-15T06:43:38.302-07:002012-03-15T06:43:38.302-07:00Control Panel -- > Administrative Tools --> ...Control Panel -- > Administrative Tools --> Services --> Right click on SQLServer (MSSQLSERVER) --> Restart<br /><br />Error 32(The process cannot access the file because it is being used by another process.) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.<br /><br />we checked the start parameter it is showing fine<br />(-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf)<br /><br />Can you please help on thisUnknownhttps://www.blogger.com/profile/11692240075386746033noreply@blogger.com