Issue with restoring the database in MS SQL server -
when try restore db in sql server getting following error message:
backup mediaset not complete. family count:2. missing family sequence number :1
i googled error , found backup of database wrote data 2 files.
but how can find files? have dropped database. have abackup copy of particular db.
you can information in msdb database after dropping database. please run below query list of backup performed on sql instance-
select bs.name,bs.backup_size, bs.database_name , bs.backup_start_date , bm.physical_device_name msdb.dbo.backupset bs join msdb.dbo.backupmediafamily bm on bs.media_set_id = bs.media_set_id order bs.backup_start_date desc
wiki
Comments
Post a Comment