Restore Backukp Errors - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Restore Backukp Errors

Author

Topic

BernKeo
Starting Member

5 Posts

Posted - 2011-02-11 : 12:40:23

This the error message that I'm receiving.
Please help?

TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'BERN-6ZW7UA9A2S'. (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: File 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ACCTivate$UBC.mdf' is claimed by 'ACCTivate$UBC_log'(2) and 'ACCTivate$UBC'(1). The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&LinkId=20476

sql_server_dba
Posting Yak Master

167 Posts

Posted - 2011-02-11 : 14:02:23

try changing the mdf and ldf names.

BernKeo
Starting Member

5 Posts

Posted - 2011-02-11 : 16:16:39

Thank you very much! it worked!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources