SQL database backup job hangs in Pre-Processing for a long time or never process a byte count.

Problem

SQL database backup job hangs in Pre-Processing for a long time or never process a byte count.

Cause

This issue occurs for several reasons:

1. If backup account does not have public and sysadmin rights on SQL  instance in question.
2. Named Pipes and TCP/IP  are not enabled on SQL Server.
3. The physical consistency check of a database is stuck and will not complete.

It also may occur if AOFO has been enabled in the backup operation.

Solution

1. Check  the account permissions:

a. Make sure that backup account has public and sysadmin rights on SQL  instance in questions. The steps vary depending on the version of SQL. See the KB's listed below:

How to add a Windows user to the sysadmin fixed server role in SQL Server 2005 as a failure recovery mechanism

support.microsoft.com/kb/937682


Guidelines on granting SQL Server sysadmin privileges

support.microsoft.com/kb/2184138


2. Enable Named pipes and TCP/IP communications on the SQL server:

a. Click Start > Run
b. Type CLIConfg
c. Select "Named Pipes" and "TCP/IP",select "Enable", and OK.
d. Restart SQL Server service.


3. Manually run a database consistency check against the SQL databases.

a. To run a DBCC CHECKDB command, follow the instructions listed in the Microsoft TechNet article below.

DBCC CHECKDB (Transact-SQL)

technet.microsoft.com/en-us/library/ms176064.aspx
 

4. Reconfigure the backup job without the Advance Option File Option (AOFO).

 


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)