When executing a
RESTORE command, I understand that SQL Server ensures that an existing database is not being overwritten by a different database. This check can be bypassed using
I understand that SQL Server uses the backup file's
FamilyGUID to determine whether the database being restored is the same as the database being overwritten. Is this correct?
I understand that the
FamilyGUID of the backup file can be determined using
RESTORE headeronly FROM DISK = N'Q:\MyBackup.bak'
But how can I find the FamilyGUID of the database that is being overwritten?