SQL Server Performance

Database Restore in SQLServer7

Discussion in 'General DBA Questions' started by OracleBomb, Jan 23, 2006.

  1. OracleBomb New Member

    Using EM, I want to Restore a Databese name CSS_BILL Using Tools |
    Restore Database, selected CSS_BILL and tried restoring it selecting
    the device from my C drive. We are using SqlServer7 with service pack1...

    The folling message thrown by sqlserver 7:

    Microsoft SQL-DMO (ODBC SQLState: 42000)


    The backup set holds a backup of a database other than the existing
    'CSS_BILL' database.


    RESTORE DATABASE is terminating abnormally.

    plzz help me how to overcome this problem


  2. satya Moderator

    From query analyzer run
    RESTORE FILELISTONLY from <backup device>
    in order to see the contents of the backup device.
    Use restore statement from query analyzer to restore, refer to books online for more information on RESTORE topic.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page