mamlaide
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Regards