-
FORMAT and SKIP
Hi guys.
While doing database disk backups, we have been using the following query
BACKUP DATABASE [xxx] TO DISK = 'e:\Backups\Database\xxx.bak'
WITH INIT , NOUNLOAD , NAME = 'Complete Backup - xxx', NOSKIP , STATS = 10, NOFORMAT
This was fine until we did an ad-hoc backup to a different filename (yyy), and then renamed the file back to the original name (xxx).
When the schedule took over the next night, the physical_device_name in [msdb].[dbo].[backupmediafamily] did not get updated to the original name (xxx), but still claimed that the physical_device_name was yyy.
I am exploring the following query to back up the database from now on:
BACKUP DATABASE [xxx] TO DISK = 'e:\Backups\Database\xxx.bak'
WITH INIT , NOUNLOAD , NAME = 'Complete Backup - xxx', SKIP, STATS = 10, FORMAT
(Note FORMAT and SKIP)
This will force the update of the physical_device_name. But the big question is:
Am I missing something? Could this have unforseen consequences?
Any ideas and opinions on this is most welcome.
Regards,
Martin
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|