MS SQL Server - Backup only new databases

Author

Backup only new databases

2006-01-26, 4:53 pm

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?

David Gugick

2006-01-26, 4:53 pm

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

Uri Dimant

2006-01-26, 4:53 pm

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?
>

Sponsored Links