Error 3154 Sql Server 2005
Contents |
log in tour help Tour Start 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 microsoft sql server error 3154 Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users
Error 3154 Sql Server 2008 R2
Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their
Ms Sql Server Error 3154
database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise
3154 Sql Server Restore
to the top Error 3154 while restoring a backup using WITH REPLACE up vote 10 down vote favorite I have SQL 2012 with SP1 installed on my computer. I made a backup of a database test.bak. I have a database with the name test2 which is the same database, but the data changed. I want to restore test.bak over test2 database. I am always getting the error: Error 3154: The backup set holds a backup of sqlserver error 3154 a database other than the existing database. I tried: I right-cliked on test2 -> Restore database -> From device I chose test.bak and checked With Replace but I get the error. Then I tried to right-click on test2 -> Restore file and filegroups I chose test.bak and checked With Replace but I get the error. I can delete my old database and then restore my backup with the right name, but when I was using SQL 2008, I had no problem restoring over an existing database. It seems that since I use SQL2012, I get this error a lot! sql-server sql sql-server-2012 backup restore share|improve this question edited Jun 20 '13 at 15:51 Aaron Bertrand♦ 113k14196334 asked Jun 20 '13 at 15:21 Danielle Paquette-Harvey 3711310 migrated from stackoverflow.com Jun 20 '13 at 15:30 This question came from our site for professional and enthusiast programmers. add a comment| 6 Answers 6 active oldest votes up vote 9 down vote accepted You should use WITH REPLACE and in general avoid using the point-and-click thingies in Management Studio - they're inflexible and often have bugs. This worked for me: USE [master]; GO CREATE DATABASE test; GO CREATE DATABASE test2; GO BACKUP DATABASE test TO DISK = 'c:\temp\test.bak' WITH INIT, COMPRESSION; GO RESTORE DATABASE test2 FROM DISK = 'c:\temp\test.bak' WITH REPLACE, MOVE 'test' TO 'c:\temp\test2.mdf', MOVE 'test_log' TO 'c:\temp\test2.ldf'; Al
| info@thewebbureau.com Enquire Close Home Who We Are What We Do Our Work Blog Get In Touch We're hiring! What We Do > error 3154 in sql server 2012 Website Design Website Design Responsive Design Mobile Design User Experience User Experience the backup set holds a backup of a database other than the existing database sql server 2012 Testing Brand Development Development Content Management Systems E-Commerce Magento Bespoke Development & Systems Integration Conversion Rate Optimisation Reporting, Review error 3154 in sql server 2014 & Analysis Digital Marketing Digital Marketing Strategy Content Marketing Email Marketing Social Media Marketing Digital Training Search Engine Marketing Pay Per Click Advertising SEO Audit & Strategy SEO Management Home http://dba.stackexchange.com/questions/44967/error-3154-while-restoring-a-backup-using-with-replace Get In Touch Blog Careers Home > Tech Blog>SQL Server Error 3154: The backup set holds a backup of a database other than the existing database. Search SQL Server Error 3154: The backup set holds a backup of a database other than the existing database. Published on 10 November 2010 Error 3154: The backup set holds a backup of a database other https://www.thewebbureau.com/sql-server-error-3154-the-backup-set-holds-a-backup-of-a-database-other-than-the-existing-database than the 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 using the RESTORE command. 2) Delete the older database which is conflicting and restore again using RESTORE command. 3) Example : RESTORE DATABASE AdventureWorks FROM DISK = 'C:\BackupAdventureworks.bak' WITH REPLACEIf this doesnt work then you may need to do one of the following:1. open up SQL Server Configuration Manager (I am using SQL Server 2005) 2. right click on SQL Sever Express (I assume it is the same for the full version of SQL Server) 3. Choose Properties 4. in the Logon tab - click the built in account radio button and choose 'Local system' from the drop down.
FROM DISK = 'd:\myfolder\TEST_FullBackup_20090823_2200.bak'WITH REPLACEORRESTORE DATABASE db_TestFROM DISK = 'C:\Documents\db_Test_FullBackup_20090624_1737.bak'WITH REPLACE Please enable JavaScript to view the comments powered by Disqus. comments powered by Disqus Keep in touchSign Up For Free Newsletters Sign up Please enter your Email Address Invalid email address - please check entry Categorie(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Database Restore, Error 3154 and SQL Server > SQL Server High Availability and Disaster Recovery Question 0 Sign in to vote https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d315d8f4-d7e2-4197-9cbb-4cbe086af33e/database-restore-error-3154-and?forum=sqldisasterrecovery Hi all, I am trying to restore and SQL 2000 database into a new SQL 2005 database. I performed by SQL 2000 backup and created a blank database FERS_Production in SQL 2005. FERS_Production was the original name of the database in the SQL 2000 instance. I have tried giving the new database the same name as the original and a different name to the original database (Below is the scripted T-SQL sql server that I get from the DB Admin tool RESTORE DATABASE [Fers_Production] FILE = N'FERS_Production_dat', FILE = N'FERS_Production_log' FROM DISK = N'D:\Microsoft SQL Server (2000)\MSSQL\Backup\Fers_Production\Fers_Production_db_200607270206.BAK' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10GO
When I run this I get the following error. Msg 3154, Level 16, State 4, Line 1The backup set holds a backup of a database other than the existing 'Fers_Production' database.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE 3154 sql server is terminating abnormally. Other searches I have performed trying to fix this problem have said to use the REPLACE clause with theRESTORE DATABASE command, butas you can see I am doing that. Also I no longer have SQL 2000 installed so I cannot try to do a DTS copy which was another suggestion I came across. Any help is much appriciated, many thanks Derek Monday, July 31, 2006 1:36 AM Reply | Quote Answers 0 Sign in to vote The restore process cannot restore the database from the backup file because there is already a database called Fers_Production present on your SQL 2005 server. Try deleting the Fers_Production database you created and then do the restore of the backup file. Monday, July 31, 2006 5:24 AM Reply | Quote All replies 0 Sign in to vote Hi all, Since I was having problems with a SQL 2000 database to SQL 2005 restore (which I have posted seperately) I tried copying the data files to a new folder and just attaching to the SQL 2000 database file from the SQL 2005 managment studio but I get the following error (I am runing service pack 1 for SQL 2005) TITLE: Microsoft SQL Server Management Studio------------------------------ Attach database failed for Server 'DATABASESERVER'. (Microsoft.SqlSer