Copy Database files from command line

Question

Hi folks,

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.

Help please.

Thanks a lot  in advance.

Answer 1

Hi,

If you cannot copy your database files, as you mentioned, they might be in use.

hmm,

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.

Cheers.

---

MCP, MCTS, MCITP

Answer 2

YES,

Thanks, it worked.