August 22, 2011 at 5:42 pm
Hi All
Actually i restore the destination database(DEV-Db) from network back up path(PROD-Db).I want to verify that datbase is restored from proper path and proper prod database back up.can any one give me query for the same.
i fire this query from which i can check which database is restore from which db.but wanna check path of back file of db also
select b.destination_database_name,a.database_name,a.server_name,* from msdb..backupset a , msdb..restorehistory b where a.backup_set_id = b.backup_set_id
August 22, 2011 at 10:49 pm
Hi,
You can find restoration information as below in the error log file which has information about backup files...
Database was restored: Database: xxxxxx, creation date(time): 2008/11/14(15:07:22) device
information: (FILE=1, TYPE=DISK: {'X:\drive\xxxxxyyyy.bak'
August 23, 2011 at 12:12 am
The query you have executed is correct and contain maximum information about the backup and restore.
Now you would like to compare the same detail with Prod-db; the way you need to do is execute the command for prod-db to get the backupset detail and manually compare.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply