Posted by Seguros Catatumbo on 11/16/07 12:41

I made a mistake with the command. My database name is not db, it's
"web". So now i get the same error i get when i do with the GUI:

RESTORE DATABASE db FROM DISK ='c:\publica\web_db_200711150500.bak'
WITH MOVE 'WEB_Data' TO 'c:\pruebadb\web_dos.mdf',
MOVE 'WEB_Log' TO 'c:\pruebadb\web_dos_log.ldf',
REPLACE

Here's the error message:

Exclusive access could not be obtained because the database is in use.

Do i need to take the database offline or something?

• Next in forum: Re: Restore a database to another server
• Prev in forum: Re: Restore a database to another server
• Thread view: Re: Restore a database to another server

[Reply to this message]