SQL Error 911 / Redgate Error 880

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

SQL Error 911 / Redgate Error 880

Postby darmstrong » Tue May 08, 2012 6:36 pm

There are four databases that have been deleted from the server, but SQL Backup is still trying to back them up. Before I deleted them from the server, I removed them from all of the backup jobs that reference them. When I edit the backup jobs, the databases are not listed.

How can I remove the databases from SQL Backup? Is there some sort of config or ini file that I need to manually edit to remove references to the databases that have been deleted?
darmstrong
 
Posts: 6
Joined: Thu Dec 23, 2010 12:12 am

Postby petey » Wed May 09, 2012 1:36 am

Could you please post the SQL Backup command that your job is using to back up your databases?

Thanks.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby darmstrong » Wed May 09, 2012 2:58 am

Peter,

How can I view the command that the application executes?
darmstrong
 
Posts: 6
Joined: Thu Dec 23, 2010 12:12 am

Postby petey » Wed May 09, 2012 7:30 am

Using Management Studio, look for the job that backs up your databases. There should be a T-SQL step that runs the backup command via SQL Backup.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 1 guest