Home > SQL Server > Solve Database Backup Problem

Solve Database Backup Problem

Hi all,

In this post i will show how to solve the error when try to backup database

Error Message :- System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName’ database. (Microsoft.SqlServer.Smo) The error Message below : Restore failed for Server ‘SQL Server name’. (Microsoft.SqlServer.Smo)

So to solve the problem, you can use the overwrite the existing database option while you’re restoring.

1) On Restore Database, select Options tab on the left menu. Then, check Overwrite the existing database on Restore options.
Note: This option will overwrite any existing data on the targeted database.

2) Try to restore the database, the problem should be gone now.
Note: you can also delete the targeted database before perform restore a database. This way also gives the result as same as the solution above.

Hope this helps

Good Luck

Categories: SQL Server
  1. sai
    October 24, 2011 at 3:04 pm

    Dear Sir,
    I want to display a report when the user selects between two dates fromdata,todate.
    i am new to programming can you guide me how to write a stored procedure for this,i would appreciate i you share your knowledge with me……

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: