• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 719
  • Last Modified:

SQL Server 2005 backup on multiple Databases in one go

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
mamlaide
Asked:
mamlaide
  • 2
1 Solution
 
pjaguilarCommented:
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
 
mamlaideAuthor Commented:
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
 
pjaguilarCommented:
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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now