Link to home
Start Free TrialLog in
Avatar of mamlaide
mamlaideFlag for United States of America

asked on

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
Avatar of pjaguilar
pjaguilar

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
Avatar of mamlaide

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of pjaguilar
pjaguilar

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial