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!

NBU 7.1.0.4 & SQL Agent

Status
Not open for further replies.

Dorga

MIS
Jul 30, 2003
101
NZ
Hi..

I am looking at backing up a couple hundred SQL servers which hold several thousand DB's..

I have the policy, and schedules setup, and the DBA then logs in one of the SQL servers, run the DB extention, tell it to backup the DB's and save the script. The DB's can now initiate user side jobs.. all good..

Now, thats one server done.. unfortunatly, the DBA's like to move DB's from server to server, and do not want to modify the scripts when they do.

What are my options to make this as easy as can be so I can run the jobs, and not have to get the DBA's to modify any scripts? Can the scripts be set to backup all existing DB's on the server?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top