Solved

SQL Server 2005 backup on multiple Databases in one go

Posted on 2011-03-17
3
711 Views
Last Modified: 2013-11-30
I have 23 databases on a SQL Server 2005 instance and wish to automate the backup procedure as
it is tedious to do them manually for all 23 databases. My backup strategy is to take a FULL backup on weekly
basis to occur every sunday at midnight. Then a DIFFERENTIAL backup from Monday through to Saturday at midnight.
During the course of the day i want to take log backups.

Having this strategy how do i go about implementing it for the different backup types
0
Comment
Question by:mamlaide
  • 2
3 Comments
 
LVL 2

Expert Comment

by:pjaguilar
ID: 35160685
Will you consider a backup software (i.e. Backup Exec)? To automate this with Backup Exec or a similar software piece is a breeze...

Regards
0
 

Author Comment

by:mamlaide
ID: 35160728
Thanks pjaguilar, My employers are not in a position to spend any more, may be in the future. We want to utilize the backup tools in SQL Server
0
 
LVL 2

Accepted Solution

by:
pjaguilar earned 500 total points
ID: 35160761
And, may i suggest, then, NTBackup? It's free and is very good for this too (it's not as fancy as BE, but...)...

If you want to use SQL, you may create a Backup Job, with SQL Management Studio (it provides a wizard that lets you choose as many databases as you want, and even creates and schedules the job)...

Regards

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question