Backup only new databases

Is there any way with SQL 2000 SP3a to backup all new databases that have
been created and have not had a full backup run yet?
CR wrote:
> Is there any way with SQL 2000 SP3a to backup all new databases that
> have been created and have not had a full backup run yet?
You could probably query the msdb.backupset table for all user databases
that do not have rows in the table (check the database_name column)
David Gugick
Quest Software
|||CR
Create a table where you store the db_id or dbnames.
insert into table (dbid,name) select dbid,name from sysdatabases
select dbid,name from sysdatabases where not exists
(select * from table where table.dbid=sysdatabases.dbid)
"CR" <a@.b.c> wrote in message news:u$MxBHhIGHA.676@.TK2MSFTNGP10.phx.gbl...
> Is there any way with SQL 2000 SP3a to backup all new databases that have
> been created and have not had a full backup run yet?
>

Backup only new databases

Is there any way with SQL 2000 SP3a to backup all new databases that have
been created and have not had a full backup run yet?CR wrote:
> Is there any way with SQL 2000 SP3a to backup all new databases that
> have been created and have not had a full backup run yet?
You could probably query the msdb.backupset table for all user databases
that do not have rows in the table (check the database_name column)
David Gugick
Quest Software|||CR
Create a table where you store the db_id or dbnames.
insert into table (dbid,name) select dbid,name from sysdatabases
select dbid,name from sysdatabases where not exists
(select * from table where table.dbid=sysdatabases.dbid)
"CR" <a@.b.c> wrote in message news:u$MxBHhIGHA.676@.TK2MSFTNGP10.phx.gbl...
> Is there any way with SQL 2000 SP3a to backup all new databases that have
> been created and have not had a full backup run yet?
>