The database is in use - that's what causes the error. You
need to make sure you aren't in the database itself when
trying to restore.
Try using something like:
USE master
go
ALTER DATABASE MyDB
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
go
RESTORE DATABASE MyDB
FROM DISK = 'c:\MyDB.bak'

-Sue

On Sat, 18 Mar 2006 18:57:25 +0200, "Sam"
[quoted text, click to view]