Backup Error

Question

Post reply

Backup Error

dba_neo

SSCrazy

Points: 2673
More actions
January 15, 2010 at 10:26 am

#386115

Hi team,
i have a scheduled job for the backup process of all databases,but the job was failed with error.
SQL Backup failed with exit code: 1010 SQL error code: 9987 [SQLSTATE 42000] (Error 50000). The step failed.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442467

January 15, 2010 at 10:31 am

#1104344

Does the database have full-text catalogs?

dba_neo SSCrazy Points: 2673 More actions · Answer 2

How to check weather the database has Full-text catalogs

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

There should be something in the SQL error log on why the backup failed. Check and see.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dba_neo SSCrazy Points: 2673 More actions · Answer 4

Thanks Gail for reply,this is the error mess i got in Error log

Failed to get configuration from server. Check that the SQL Server instance is running and that you have the SQL Server System Administrator server role. Error code: <value>. [Also check that the database is not currently in use.]

For certain timeout conditions, a more detailed description may be presented with this error code:

Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role, and that no other processes are blocking the backup or restore process. If the problem recurs, try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName].or,

Failed to get the configuration from the server because the timeout interval has elapsed. SQL Backup required <bytes> bytes of free SQL Server memory, which was not available. [You can reduce the memory requirements by reducing the number of backup files/threads used in the backup.

To configure the VDITimeout registry key, open the registry editor, locate the SQL Backup entries for the relevant SQL Server instance, and add a DWORD entry named "VDITimeout". Enter a duration that you feel is adequate for SQL Server to respond. The duration must be entered in seconds (in hexadecimal).

dba_neo SSCrazy Points: 2673 More actions · Answer 5

HI,can any one have the solution for this problem?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

One, I don't use Redgate SQL Backup. Two, it looks like the error message basically tells you what you need to do.