Cannot restore deleted Database in SQL Server 2008
Posted on 2011-05-06
Good day everyone,
I have logshipping enabled for several databases, it works fine in them all but there is a couple which are giving me this error when I try to restore them:
System.Data.SqlClient.SqlError: File 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DATABASENAME.mdf' is claimed by 'DATABASENAME_log'(2) and 'DATABASENAME'(1). The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo)
I had restored them before for testing and it worked, but some weeks after when I wanted to enable logshipping for real using fresh back ups to restore I am getting this all the time. I even removed the database but still having the same issue, no way I can restore it.