Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Microsoft SQL Server: Setup and Administration FAQ


How do I automate the backups of my Databases and Transaction Logs? by ecobb
Posted: 24 May 03 (Edited 1 Jul 03)

This can easily be done in Enterprise Manager.  Just click on the "management" folder and right click on "Database Maintenance Plans" and then select "New Maintenance Plans".  This will take you through a wizard that will set up and schedule backups of the database and/or transaction logs as often as you would like them to occur.  

By using this method, SQL Server will be able to perform the backups without having to shut down the databases, it can even backup databases while they are being used.

Back to Microsoft SQL Server: Setup and Administration FAQ Index
Back to Microsoft SQL Server: Setup and Administration Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close