'Restore failed for server' error...

  • Hi,

    I am new in the db world. I have a full backup file from one sql server box copied to another server which I have installed same version of sql (sql2005). When I try to restore, I get this error, how do I get around it? thnx:

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    Restore failed for Server 'i-Control-Server'. (Microsoft.SqlServer.Smo)

    ------------------------------

    ADDITIONAL INFORMATION:

    System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'AMI_VTS' database. (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476

  • Hi,

    Found the solution! I just set restore options to overwrite and the restore drive was different in the backup machine.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply