November 17, 2014 at 7:14 pm
Hi there,
Just want to ask if theres a way on sql management studio 2005, to create one job for one database having steps and scheds ( daily, weekly, monthly ) to do backup to my database.
My Steps consist of commands where to store my backup files ( ex. step 1 for database 1 to be save on daily folder that i created, step 2 on d:/____/_____/weekly/week1/database1_kbp/, step 3 d:/____/____/weekly/week2/database1_bkp/ and so on
please help thanks,
November 17, 2014 at 8:00 pm
artbalauro (11/17/2014)
Hi there,Just want to ask if theres a way on sql management studio 2005, to create one job for one database having steps and scheds ( daily, weekly, monthly ) to do backup to my database.
My Steps consist of commands where to store my backup files ( ex. step 1 for database 1 to be save on daily folder that i created, step 2 on d:/____/_____/weekly/week1/database1_kbp/, step 3 d:/____/____/weekly/week2/database1_bkp/ and so on
please help thanks,
Just a suggestion... you're busting up you backups by week and that's going to be really difficult to manage especially when it comes to deleting old backups. My recommendation would be to name the files using the database name and the date/time of the start of the backup and have ALL the backups for a given database in a single directory.
As for doing the actual backups, I use stored procedures that figure out what needs to be done for my particular instances and the databases on a given instance. My backup job for full backups has just one line in it... EXEC DBA.util.FullBackups.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply