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

Popular posts from this blog

Asterisk AGI Python Script to Dialplan does not work -

kotlin - Out-projected type in generic interface prohibits the use of metod with generic parameter -

python - Read npy file directly from S3 StreamingBody -