I have a very bad issue.
Something has happened in our Windows Server 2003 Server and we cannot access to dtabase files from explorer.
We need to copy them to a safe place to solve the server problem and recover the databases again.
I have access to files from command line but it seems tha databases are in use so we I am not able to copy them.
Thanks a lot in advance.
If you cannot copy your database files, as you mentioned, they might be in use.
You have to stop your SQL Server service from CMD using "net start MSSQLSRV" which MSSQLSRV is the name of your sql server instance.
After your SQL Server Sevice stops successfully you will be able to copy your databases from command line.
MCP, MCTS, MCITP
- 已标记为答案 Glen1983 2012年8月5日 3:36
Thanks, it worked.