last backup - how many backup files and where they are?

1 vote

2 answers

136 views

                          I am restoring a database, this database is very big and it has 6 backup files (meaning the backup is split into 6 smaller files)
I can see an indication of that using the restore labelonly  

> MediaFamilyId	uniqueidentifier	Unique identification number for the
                                    media family. 

> MediaSequenceNumber	int	Sequence number of this media in the media family.

here are the restore commands:

       restore filelistonly 
         FROM DISK = '\\MY_BACKUP_SERVER\SQLBackups\MY_SERVER\MY_DATABASE\FULL\MY_SERVER_MY_DATABASE_FULL_20231215_180002_6.bak'
    
     restore labelonly
      FROM DISK = '\\MY_BACKUP_SERVER\SQLBackups\MY_SERVER\MY_DATABASE\FULL\MY_SERVER_MY_DATABASE_FULL_20231215_180002_6.bak'
    
    restore headeronly
       FROM DISK = '\\MY_BACKUP_SERVER\SQLBackups\MY_SERVER\MY_DATABASE\FULL\MY_SERVER_MY_DATABASE_FULL_20231215_180002_6.bak'

My question is, how can I find (in this case 6) files inside msdb?

Basically a query to get these 6 - the last full backup - restore these (6) files.

Asked by Marcello Miorelli (17274 rep)

Dec 19, 2023, 04:53 PM
Last activity: Dec 19, 2023, 07:13 PM

last backup - how many backup files and where they are?

Related Questions