Brandon,

I am attempting this via SSMS.

The problem now for me is that the server is located at a client site and if I attempt to restore and it locks I need someone to physically go to the server and re-boot. In addition, the server is used for other file server functions and I cannot attempt during business hours.

I will attempt this tonight. In the meantime, Do you know of a situation where changing to single user mode made a difference in what I am attempting to do?

Bob
>Are you doing this through T-SQL or SQL Server Management Studio?
>
>Try forcing database to single user mode first.
>
>ALTER DATABASE MyDatabase SET SINGLE_USER WITH ROLLBACK AFTER 10
>
>then after restore is successful
>
>ALTER DATABASE MyDatabase SET MULTI_USER
>
>
>I use SQL Server 2008 so this may need tweaking for 2005.