Micorosoft SQL Server, Error:3154
The following errors pop up today when I was trying to restore a database for a user in SQL 2005.
The backup set holds a backup of a database other than the existing database. RESTORE DATABASE is terminating abnormally. ( Micorosoft SQL Server, Error:3154)
You may get the backup restored using the following T-SQL
RESTORE DATABASE [DBName] FROM DISK = N’C:\DBBackup.bak‘ WITH FILE = 1, REPLACE,STATS = 10
If you enjoyed this article please consider sharing it!
Post comment
Categories
Recent Posts
- yum update – TypeError: unsubscriptable object
- Magento with Windows IIS
- Helm3 : File Manager Not Showing any Files
- Helm4 Error on Remove Domain
- SQL 2008 Maintenance Plan Execution Error
Recent Comments
- tbx on Cannot create Windows Service for MySQL.Error:0
- bhumi on Cannot create Windows Service for MySQL.Error:0
- Sue on Cannot create Windows Service for MySQL.Error:0
- Shubham on Cannot create Windows Service for MySQL.Error:0
- Tommy on Cannot create Windows Service for MySQL.Error:0
Archives
- September 2009
- May 2009
- April 2009
- March 2009
- November 2008
- August 2008
- July 2008
- May 2008
- April 2008
- March 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- March 2007
