Differential maintenance in plan sql 2000: setup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scottg - 30 Mar 2008 03:00 GMT

Hello!

I'm trying to setup a differential maintenance plan to backup all
users databases on sql 2000 using t-sql (or not)

I can't figure out or find how to include "all user databases" like i
would using a maintenance plan. This is a cake to do in sql 2005 but
sql 2000..... well lets just say :(

Reply to this Message

Tibor Karaszi - 30 Mar 2008 08:55 GMT

There are maint plans in 2000, which you reach from the Maintenance Plans folder in EM. A 2000 maint
plan do not include diff backups, though.

Right-licking a db and select Backup and from there selecting Schedule do *not* create a maint plan.

So if you want to include stuff like naming the backup file with time stamp and deletion of old
backups, you have to do it yourself. There are plenty of code out there to get your started, for
instance below (2005, but adaptable for 2000):
http://www.karaszi.com/SQLServer/util_backup_script_like_MP.asp

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hello!
>
[quoted text clipped - 4 lines]
> would using a maintenance plan. This is a cake to do in sql 2005 but
> sql 2000..... well lets just say :(

Reply to this Message