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
mamlaideAsked:
Who is Participating?
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.