SQL-Server: The backup set holds a backup of a database other than the existing

by

I too came across this issue.

Solution :

  • Don’t create an empty database and restore the .bak file on to it.
  • Use ‘Restore Database’ option accessible by right clicking the “Databases” branch of the SQL Server Management Studio and provide the database name while
    providing the source to restore.
  • Also change the file names at “Files” if the other database still exists. Otherwise you get “The file ‘…’ cannot be overwritten. It is being used by database ‘yourFirstDb'”.

More Related Contents:

  1. If condition in SQL Server 2008
  2. How to get the last row from a table in SQL Server?
  3. Comma separated results in SQL
  4. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  5. Which are more performant, CTE or temporary tables?
  6. Storing a file in a database as opposed to the file system?
  7. Preferred Method of Storing Passwords In Database
  8. How do you count the number of occurrences of a certain substring in a SQL varchar?
  9. Why is it considered bad practice to use cursors in SQL Server?
  10. Import Excel spreadsheet columns into SQL Server database
  11. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  12. SQL WHERE.. IN clause multiple columns
  13. Query to list all stored procedures
  14. How do I search an SQL Server database for a string?
  15. WHERE clause on SQL Server “Text” data type
  16. SQL Server – parameter sniffing
  17. Does the order of columns in a WHERE clause matter?
  18. How can I select from list of values in SQL Server
  19. Configure Lucene.Net with SQL Server
  20. SQL Server tables: what is the difference between @, # and ##?
  21. Forcing a query timeout in SQL Server
  22. Sql Server – connect with windows authentication
  23. SQL Rows to Columns
  24. SQL Server – Auto-incrementation that allows UPDATE statements
  25. What is the best way to implement Polymorphic Association in SQL Server?
  26. Set option 9 in SQL Server stored procedure using WinHttp.WinHttpRequest.5.1 for TLS 1.2
  27. How to maintain the order of insertion in SQL Server
  28. SQL Server equivalent to Oracle’s CREATE OR REPLACE VIEW
  29. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  30. Oracle sequence but then in MS SQL Server

Leave a Comment