Creating Standard Backups Via MSSQL Enterprise Manager

Question

Creating Standard Backups Via MSSQL Enterprise Manager

oakvick

SSC Journeyman

Points: 80
More actions
April 18, 2005 at 6:09 pm

#185723

We have a product that creates databases automatically. My questions pertain to automating standard MSSQL backups of newly created databases. Is it best to just reconcile at day's end those new databases and then create backups manually via Enterprise Manager? If it is an okay practice to program triggers to create backups, can someone point me to information outlining how this can be done. Note: when I am talking about backups, I am talking about fulls, diffs and trans logs.
Thank you, Joe

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Kishore-132325 Hall of Fame Points: 3784 More actions · Answer 1

You can write a automated script to query sysdatabases table, pick up all the databases and backup those everyday. You could schedule it using SQL Server jobs to run on a scheduled time.

--Kishore

tosscrosby Hall of Fame Points: 3140 More actions · Answer 2

You can also use the maintenance plans and specify "All user databases". This way, as new databases are added, they'll automatically be backed up without any changes by you to the plan.

Terry

oakvick SSC Journeyman Points: 80 More actions · Answer 3

oakvick

SSC Journeyman

Points: 80

April 20, 2005 at 3:21 pm

#553927

Thanks Terry. I will give that a go!

Joe

oakvick SSC Journeyman Points: 80 More actions · Answer 4

Okay, I created a database maintenance plan with the wizard and have found out invariably as others have before me that differential backups are not part of the database maintenance plan.

Can we augment the script that is generated with the database maintenance wizard? I tried looking at other articles pertaining to the same on the Internet but have not found anything yet. Anyone have any suggestions?

Joe

philcart SSC-Forever Points: 47796 More actions · Answer 5

Best bet is to take the path of many before you and roll your own backup and maintenance routine.

Take a browse through the Script Library here and I'm sure you'll find something to get you started.

--------------------
Colt 45 - the original point and click interface

oakvick SSC Journeyman Points: 80 More actions · Answer 6

Thanks for setting me straight Phill. I will do as you suggest!

Joe