Differential maintenance in plan sql 2000: setup

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
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
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"scottg" <scottgranado@.gmail.com> wrote in message
news:f9f653f3-f0c6-4cb8-ae3e-4694a380293f@.n58g2000hsf.googlegroups.com...
> 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

Differential maintenance in plan sql 2000: setup

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 :(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
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"scottg" <scottgranado@.gmail.com> wrote in message
news:f9f653f3-f0c6-4cb8-ae3e-4694a380293f@.n58g2000hsf.googlegroups.com...
> 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 :(

Differential backup vs Log Shipping

Hello,
I'm trying to figure out the most effective way to have a standby database
in remote location (connected by reliable broadband link).
The option which I'm looking at are log shipping and differential backups.
As far as I understand with log shipping all I have to do is to periodically
apply transacton logs to original full restore database and be good forever.
On the other hand if I use differential restores, I need to restore full
backup to standby server each time I do full backup at origin server, right?
Original database is 10 Gb so does it mean with differential backup scenario
I would have to copy 10 Gb each time I do full backup on source server?
Are there any advantages in using differential backup as opposed to log
shipping method?
On a separate note what is effect of full and transaction log backups on log
shipping process?
"ChanKaiShi" wrote:

> Hello,
> I'm trying to figure out the most effective way to have a standby database
> in remote location (connected by reliable broadband link).
> The option which I'm looking at are log shipping and differential backups.
> As far as I understand with log shipping all I have to do is to periodically
> apply transacton logs to original full restore database and be good forever.
> On the other hand if I use differential restores, I need to restore full
> backup to standby server each time I do full backup at origin server, right?
> Original database is 10 Gb so does it mean with differential backup scenario
> I would have to copy 10 Gb each time I do full backup on source server?
> Are there any advantages in using differential backup as opposed to log
> shipping method?

Differential backup vs Log Shipping

Hello,
I'm trying to figure out the most effective way to have a standby database
in remote location (connected by reliable broadband link).
The option which I'm looking at are log shipping and differential backups.
As far as I understand with log shipping all I have to do is to periodically
apply transacton logs to original full restore database and be good forever.
On the other hand if I use differential restores, I need to restore full
backup to standby server each time I do full backup at origin server, right?
Original database is 10 Gb so does it mean with differential backup scenario
I would have to copy 10 Gb each time I do full backup on source server?
Are there any advantages in using differential backup as opposed to log
shipping method?On a separate note what is effect of full and transaction log backups on log
shipping process?
"ChanKaiShi" wrote:

> Hello,
> I'm trying to figure out the most effective way to have a standby database
> in remote location (connected by reliable broadband link).
> The option which I'm looking at are log shipping and differential backups.
> As far as I understand with log shipping all I have to do is to periodical
ly
> apply transacton logs to original full restore database and be good foreve
r.
> On the other hand if I use differential restores, I need to restore full
> backup to standby server each time I do full backup at origin server, righ
t?
> Original database is 10 Gb so does it mean with differential backup scenar
io
> I would have to copy 10 Gb each time I do full backup on source server?
> Are there any advantages in using differential backup as opposed to log
> shipping method?