Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Directives 3

Status
Not open for further replies.

polar1

MIS
May 14, 2001
31
US
Does anyone know to code a directive for SQL Servers?
I would like to backup all but 1 database.
 
what we use is the following:
in the savesets we have specified
MSSQL:dbname1
MSSQL:dbname2

I guess you could do this for as many db's you want to
backup. we have done this to prevent the demodb being backed up.
if you do it like this you will always see which db's you are backing up.

 
This is also the only way to do scheduled differential or incremental backups. Specifying only MSSQL: will do a full backup everytime, which kills us becuase we have 150+ gig databases here.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top