SQL Error 911 / Redgate Error 880

Compresses, encrypts, secures and monitors SQL Server backups.

SQL Error 911 / Redgate Error 880

Postby darmstrong » Tue May 08, 2012 5: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: Wed Dec 22, 2010 11:12 pm

Postby petey » Wed May 09, 2012 12: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 8
petey
 
Posts: 2335
Joined: Sun Apr 24, 2005 11:34 am

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

Peter,

How can I view the command that the application executes?
darmstrong
 
Posts: 6
Joined: Wed Dec 22, 2010 11:12 pm

Postby petey » Wed May 09, 2012 6: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 8
petey
 
Posts: 2335
Joined: Sun Apr 24, 2005 11:34 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests