restoring to backup server - 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

General SQL Server Forums

New to SQL Server Programming

restoring to backup server

Author

Topic

jshurak
Starting Member

44 Posts

Posted - 2008-05-01 : 14:52:12

I'm trying to restore databases to a backup server from a production server. This is the message I received. I'm fairly new to this. I haven't touched SQL Server in over a year and wasn't very proficient back then either. Any help would be greatly appreciated!


TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'ULTIPROBAK'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'HRMS_GLOBALDATA' database. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

-Jeff

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-01 : 14:58:34

Use the WITH MOVE clause of the RESTORE DATABASE command. If using the GUI, go to the Option tab and specify new locations for the files or new file names.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

jshurak
Starting Member

44 Posts

Posted - 2008-05-01 : 15:32:26

thanks, I'll give that a try

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources