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
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.
