Late every evening a scheduled task executes the following command, where the target disk file's path contains the day of the week. Prior to running the command the script removes the backup from the prior week, thus I have 7 generations. A job
that runs a bit later moves the backup file to an off-site location. I would rather not run SIMPLE backup mode, as I'd like to retain the ability to go back to transactions that occurred earlier in the day. (Haven't had to yet, but who knows!) .
WIth the 7 generations I can get something that happened within the last 7 days by restoring to a different database and then copying record(s) as needed. I've only done this a few times as a test, never needed it in production. The backup script
isn't very special...
BACKUP DATABASE [CANDB]
TO DISK=N'D:\SQLbackup\{dayofweek}\CANDB.BAK' WITH INIT;
This has been running properly for several years.
My .mdf file is&n ...
Go to the complete details ...