How can we help you today? How can we help you today?

SQL Server 2000 Maintenance Plans

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
0

Comments

2 comments

Sort by
  • 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.
    RB
    0
  • 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
    Jason Cook
    0

Add comment

Please sign in to leave a comment.