Will databases be deleted if folder is based on date?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Will databases be deleted if folder is based on date?

Postby aultmike » Thu Jan 31, 2013 9:25 pm

In the backup wizard, step 3 of 6 under the Backup location section:

If this is my Folder specification: C:\\000\\<DATETIME yyyy_mm_dd>\\ AND I turn on the "Delete existing backup filies in this folder for the selected databases" will this housekeeping actually work?

I wonder because the folder name would change everyday... is the program smart enough to search these folders and delete databases that full under its criteria?

Thanks!
Mike Murphy
aultmike
 
Posts: 26
Joined: Fri Jan 08, 2010 3:49 pm
Location: Canton, OH

Postby petey » Fri Feb 01, 2013 7:10 am

No, SQL Backup won't be able to delete the old files. It only looks in the folder(s) where the current backup file(s) are stored.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2226
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests