SQL SERVER 2005 Restore Backup database

Question

SQL SERVER 2005 Restore Backup database

yogendrasoni

SSC Journeyman

Points: 95
More actions
May 31, 2010 at 11:47 am

#225202

My client provided me a backup of sql server 2005 database and while i am trying to restore the same on my win2003 machine getting below error
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'SMARTHOM\SQLEXPRESS'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The backup set holds a backup of a database other than the existing 'EpitomeRAC' database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=3154&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

I've never had that error, but I'd ask how big the restored file is because you're limited to 4Gb after the restore is complete.

After comming up dry with google search I'd ask the client to take another backup (to which I'd supply the command to make sure there's no problem) and then you should be good to go.

george sibbald SSC Guru Points: 104210 More actions · Answer 2

Are you trying to restore over the existing EpitomeRAC database? Do the logical filenames match?

Please supply the restore command you used.

---------------------------------------------------------------------

Robert Davis One Orange Chip Points: 28027 More actions · Answer 3

You're trying to restore the database over an existing database. It appears that you are using the GUI, so in this case, you need to choose the option to overwrite the existing database. If using TSQL, you have use the REPLACE option.

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

is the backup they have sent you definitely a full backup? Post the results of the following query

restore headeronly from disk = 'drive:\path\backupfilename.bak'

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

engr_faruque SSC Enthusiast Points: 192 More actions · Answer 5

Restore Data With New Name

==============

RESTORE DATABASE Business_Data_TSQL

FROM DISK='d:\Business_Data.bak'

WITH

MOVE 'Business_Data' TO 'D:\TSQL\Business_Data.mdf',

MOVE 'Business_Data_log' TO 'D:\TSQL\Business_Data_log.ldf'