Microsoft Sql Server 2012 Error 3154
Contents |
SERVER - FIX : Error 3154: The backup set holds a backup of a database other than the existing database September 27, 2007Pinal DaveSQL, SQL Server, SQL Tips and Tricks294 commentsOur Jr. DBA the backup set holds a backup of a database other than the existing database sql server 2008 r2 ran to me with this error just a few days ago
Error 3154 In Sql Server 2014
while restoring the database.Error 3154: The backup set holds a backup of a database other than the
Cannot Be Overwritten. It Is Being Used By Database
existing database.Solution is very simple and not as difficult as he was thinking. He was trying to restore the database on another existing active database.Fix/WorkAround/Solution:1) Use WITH REPLACE while
With Replace
using the RESTORE command. View Example2) Delete the older database which is conflicting and restore again using RESTORE command.I understand my solution is little different than BOL but I use it to fix my database issue successfully.3) Sample Example : RESTORE DATABASE AdventureWorks
FROM DISK = 'C:\BackupAdventureworks.bak'
WITH REPLACEReference : directory lookup for the file Pinal Dave (http://blog.SQLAuthority.com) Tags: SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts41Related Articles SQL SERVER - Solution - Puzzle - Challenge - Error While Converting Money to Decimal December 5, 2010Pinal Dave SQLAuthority News - Storage and SQL Server Capacity Planning and configuration - SharePoint Server 2010 May 16, 2010Pinal Dave SQL SERVER – Check the Isolation Level with DBCC useroptions May 24, 2010Pinal Dave 294 comments. Leave new Emjay July 24, 2014 1:17 amVery nice solution. Worked without any hitchReply Elisha Horance July 31, 2014 8:12 amYou rule. Like so many solutions, elegantly simple once you know how.Reply Niru August 22, 2014 5:59 pmThanks it workedReply AlfonsoPeru September 22, 2014 3:43 amExcellent !!!! You save mi head!!!Reply nisha October 21, 2014 5:07 pmthanks a lot it helped me :)Reply ankur November 20, 2014 1:58 amThis solution was not working for me. I had an empty database & try to restore with replace. It was throwing same error. Than I deleted empty database & tried to restore
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Error 3154: The backup set holds a backup of a database other than the logical file is not part of database use restore filelistonly to list the logical file names existing 'xx' database. SQL Server > SQL Server Tools Question 0 Sign system data sqlclient sqlerror the backup set holds a backup of a database other than the existing in to vote HELP! This is happening with a restore to SS 2005 from a SS2000 backup. This article says file cannot be restored to use with move to identify a valid location for the file to use the 'WITH REPLACE' clause. The SS2005 management studio does not seem to allow this via the GUI. http://msdn2.microsoft.com/en-us/library/aa238217(sql.80).aspx Saturday, February 03, 2007 4:56 PM Reply | Quote Answers http://blog.sqlauthority.com/2007/09/27/sql-server-fix-error-3154-the-backup-set-holds-a-backup-of-a-database-other-than-the-existing-database/ 9 Sign in to vote Did you use the overwrite flag in the GUI if the database already existed ?HTH, Jens K. Suessmeyer.---http://www.sqlserver2005.de--- Sunday, February 04, 2007 8:08 PM Reply | Quote Moderator All replies 9 Sign in to vote Did you use the overwrite flag in the GUI if the database already existed ?HTH, Jens K. Suessmeyer.---http://www.sqlserver2005.de--- Sunday, February 04, 2007 8:08 PM Reply https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e9e575f6-f034-4813-82c0-3b399118b72c/error-3154-the-backup-set-holds-a-backup-of-a-database-other-than-the-existing-xx-database?forum=sqltools | Quote Moderator 0 Sign in to vote True and you can use the Query Editior to restore the same using RESTORE DATABASE .... WITH REPLACE, as referred in BOL it is easy. Monday, February 05, 2007 4:48 PM Reply | Quote Moderator 0 Sign in to vote Hi all, I am facing this problem, when i try to restore a file in a database. Scenario Database ABC with 1 Filegroup and 8 Files and 1 Log. Now i want to restore the Database ABC to another Server as ABC. due to space constraint i have thought of file backup and Restore. So i backuped up the first file, when i want to restore, It say the error. I have given overwrite existing media and i tried it with media as well as disk. Can someone help me? Monday, December 24, 2007 6:51 AM Reply | Quote 0 Sign in to vote Would be easier for us to help you, if you could send us the whole error message. Tuesday, January 01, 2008 10:27 PM Reply | Quote Moderator 0 Sign in to vote I've
And Restore SQL Backup? Error: When users try to restore SQL database from its backup sometimes errors are displayed like: This SQL server error 3154 can make you think that your SQL database has been lost http://www.sqlrecoverysoftware.net/blog/sql-server-error-3154.html forever as the only hope left to fetch back the lost database was this backup and now this backup file too is showing errors. Download Now Purchase Now Reason: However the error itself will tell you http://stackoverflow.com/questions/3479725/restoring-a-backup-with-sql-server what wrong has happened with your backup database but sometimes knowing root cause is not enough to overcome the issue. When we analyze the cause for the error displayed, it becomes clear that the name sql server of database to which you want to restore this backup set and the database of which backup is, are same. But the only difference is CREATE DATABSE statement between both databases. This means that the only similarity is of name, however the databases are completely different from each other. Other probable reasons can be: For log shipping multiple databases were configured. Transaction logs for databases were backed up to same folder. The the backup set only difference between the databases names is "_tlog" in the name. For example, xyz_test and xyz_test_tlog. Operation: Try restoring the backup set to a different SQL database with a different name. But before doing this make sure that files which will be created do not exists already and is not being used by any other database. You can also overwrite the already existing database through RESTORE DATABASE command using WITH REPLACE clause. You can use below mentioned command in T-SQL. Limitation: Sometimes the backup still is not restorable then it is confirmed that the severity of the error is major. Moreover the above mentioned technique is no doubt easy but is only for the programmers. In case you are not a tech savvy personal or the above mentioned is not working for you then you should opt for a professional help to resolve the SQL backup corruption and restore the database without any error messages. For such professional need for SQL Server error 3154 or any other corruption you can opt for SQL Backup Recovery software so that without any errors and need for programming you are capable to restore the SQL database from .bak file. Copyright © 2012 – 2016 | All rights reserved Legal | Sitemap | Google Sitemap | ROR
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Restoring a Backup with SQL Server up vote 2 down vote favorite I have a SQL Server database that I am trying to restore. My source database was on a SQL Server 2005 installation. My new server is a SQL Server 2008 machine. I have backed-up the database on the SQL Server 2005 installation. I am trying to restore it onto the SQL Server 2008 installation. When I try to restore the backed-up database, I receive an error that says: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'DBSERVER'. (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: 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 'MyDatabase' database. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=3154&LinkId=20476 What is the problem? What am I doing wrong? I have checked the "Overwrite existing database (WITH REPLACE)" box on the Options page. Thank you sql-server-2008 share|improve this question asked Aug 13 '10 at 18:35 user208662 4,030215780 add a comment| 1 Answer 1 active oldest votes up vote 8 down vote accepted You should verify that the destination directories exist for the database. By default the database files will be restored to the directories from which they came. It's likely that the destination directory doesn't exist because the SQL Server 2005 default location is different than the SQL Server 2008 default location. You can look at the Options page, "Restore the database files as..." section in the Restore dialog. It contains a list of files that will