SQL Help

[schubb2003]

Hi,
Our DBA is out and I need to change a bch file to use a specific policy. Is there an option for setting the policy in the bch file? We don't have access to the DB, but we have to set up the backup. He has logged in as an SQL admin to the agent, but I am getting random 239's. However immediately re-running the schedule again will back them up. It tries to run in the default all policy.

I know that NBSCHED will allow me specify a schedule from multiple policies, but not how to specify the policy I need it to use.

Thanks,
schubb

 

[schubb2003]

Got it. All that is needed is to add POLICY policyname to the bch file.

Too bad the SQL API documentation can't spell that out.