Scheduled backups are not placed in individual folders

Compresses, encrypts, secures and monitors SQL Server backups.

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

Scheduled backups are not placed in individual folders

Postby Oliwa » Fri Mar 23, 2012 12:11 am

Hey there,

On my Server Options screen I have the "File name format" define as...

<DATABASE>\\<DATABASE>_<TYPE>_<DATETIME yyyymmdd_hhnnss>

But my schedules backups are not placed in a folder per database. All files are placed in the root of the "Backup folder"

Any ideas?
Oliwa
 
Posts: 28
Joined: Thu Jan 11, 2007 6:15 pm

Postby Oliwa » Fri Mar 23, 2012 12:16 am

I figured it out. You have to put the <DATABASE> tag on the folder and not the file.
Oliwa
 
Posts: 28
Joined: Thu Jan 11, 2007 6:15 pm

Postby Brian Donahue » Mon Mar 26, 2012 10:33 am

Thanks for following up.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests