Plip's Weblog

Phil Winstanley - British .NET chap based in Lancashire. Enjoys tea and tech. Working for Microsoft.

SQL Server 2005 Backups

This post is more for my memory than anything else but ... I've had issues restoring a SQL 2005 database from a backup today using the SQL Workbench with the following error message: -

The backup set holds a backup of a database other than the existing 'MyDatabase' database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)

I spoke to a good friend (Tony Rogerson) and he sent me a command to run: -

restore database MyDatabase from disk = 'C:\MyDatabaseBackup\MyDatabase.BAK' with replace

And it worked a treat!

Posted: Oct 26 2006, 02:40 PM by Plip | with 8 comment(s)
Filed under: ,

Comments

Inala Shankar said:

Thats a great info....i appreciate your contribution...Thank you

# February 20, 2007 5:28 PM

PRINCE V said:

Tony Rogerson hey good work , your can be a icon for everyone who want to serve other people.

KEEP DOING THE GOOD WORK

# March 7, 2007 4:11 AM

Roni said:

restore database MyDatabase from disk = 'C:\MyDatabaseBackup\MyDatabase.BAK' with replace

thats good...i was wondering if u can help me out in writing a batch file so i can execute this command in order to compile a restore from a backupd atabase using sql server 2005 express edition...i have it installed somewere in the office and i want to know if it will restore the database.

# May 3, 2007 2:24 AM

Narendra said:

Thanks for giving good information.

# October 24, 2007 2:28 AM

Jacob Egholm said:

Great tip. The command worked like a charm:o)

# February 25, 2008 3:42 PM

ants said:

What else can u say but thanks to a man who jotted down a command on the net to save not just himself but many others like me....Thanks man

# March 4, 2008 2:34 AM

Raja said:

Wow!!!!!!!!!! Excellent man. Thanks for sharing it with us

# April 29, 2008 4:57 PM

mahantesh said:

i tried it,,,but its giving me syntax error..

# July 17, 2009 7:30 AM