We will create the desired scenario by performing a series of backup operationsīelow is the script that will do the above items. To, the start and end times of the backup operations as well as the start and end From the system tables we can tell the database that each backup set belongs Querying the backupset and backupmediafamily system tables (see Practice2017 while on the instance where the backups were created, we can easily do that by If we want to examine the backups from database Insert into staff values ('Hillary Onyema',getdate()-3)įrom the SQL statements in Listing 1, we can deduce two key factsīackup sets are written to the same media set and to the same set of backup devicesīackup sets are named, but some names are incorrect Insert into staff values ('Gen Lee',getdate()-3) Insert into staff values ('Charles Green',getdate()-3) Insert into staff values ('Kenneth Igiri',getdate()-1) Select name as from sys.databases ĭisk='G:\Backup\Practice2017_Backup_01.bak',ĭisk='G:\Backup\Practice2017_Backup_02.bak',ĭisk='G:\Backup\Practice2017_Backup_03.bak',ĭisk='G:\Backup\Practice2017_Backup_04.bak'Ĭreate table staff (ID int identity (1,1) Listing 1: Perform Multiple Backup Operations to Same Backup Devices #.BAK FILE VIEWER SERIES# We can also get the full path to the backup devicesįirst, we observe the result sets works as advertised. We are able to see ALLīackup Sets written to this Media Set.
Of backup the backup set contains – Full Database Backup (1), Differentialīackup (5), Transaction Log Backup (2) and so on (see above image). Tells us who took the backup and the server details of the source instance – #.BAK FILE VIEWER FULL# Instance name, database name and version. Knowing the type of backup, we are dealing With will help us determine what order to perform recovery. Shows the issue with the wrong names used in the backup operations we pointed out earlier. We must identify the backup set we are interested in using the FILE=# clause as We have several backups written to one Media Set, when performing an actual restore, Knowing the version of the source instance helps us determine whether we can restoreĪnother very important column to look at is the Position column.
0 kommentar(er)
