Backup file is not restoring into Database even after giving message as restored successfully
-
Hi, I have taken a backup of one Database DBa, then I created a new Database that's DBb, I tried to restore the Database DBb, message says Database restored successfully but still the new DBb doesn't get any Tables, Views or SPs in to this new Database DBb. When I am taking the backup options that I have taken are as below: in General tab, 1. Backup Type: Full 2. Copy only Backup in Options tab: 1. Backup set will expire: I have taken more than 1000 or 100 max number In the restore I have taken the options of: Restore -> Database in that In General Tab: Selected "Device" then selected the file In Options tab: 1. Overwrite existing Database 2. Close existing connections. Then OK, Is there any mistake I did either in taking the backup or in restoring the Db, but the message says, the Database is restored successfully but restore doesn't create any tables views or any object of the backup file, I am not understanding, any help would be greatly helpful, please, the message is so misleading for me. Thanks in advance