SQL Server 2000 Maintenance Plans

RB

Hi,

My organisation use SQL 2000 maintenance plans across the SQL Server estate, can I create/edit these to use SQL Backup compression functionality?

Thanks

RB

Hi,

Could I please have a response on to this question, it's been 2 weeks now. I am evaluating SQL Backup against LiteSpeed and need an answer asap.

Jason Cook

Hi RB,
While SQL Backup doesn't offer explicit support for maintenance plans per-say, you can generate Transact-SQL code that can be inserted into the maintenance plans by hand.

The following is an example Transact-SQL statement that would compress the generated backup file (and automatically name it, for example with a timestamp):

execute master..sqlbackup '-SQL "BACKUP DATABASE [mydatabase] TO DISK = ''c:\backups\<auto>.sqb'' WITH COMPRESSION = 2"';

Alternatively, you can use the Scheduling Wizard in the SQL Backup 5 user interface to generate SQL Server Agent jobs that can perform the backups - which will offer much the same functionality as maintenance plans will.

If you need any more information or specifics, let us know.

Hope that helps,
Jason