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

  • Article ID:100027692
  • Modified Date:
  • Product(s):

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).

 


Was this content helpful?

Get Support