What are the challenges you face when working across database platforms? Take the survey

SQL Server 2000 Maintenance Plans

RBRB Posts: 3
edited July 25, 2007 12:46PM in SQL Backup Previous Versions

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



  • Options

    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.
  • Options
    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,
Sign In or Register to comment.