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

Article:TECH197099  |  Created: 2012-09-21  |  Updated: 2014-01-22  |  Article URL http://www.symantec.com/docs/TECH197099
Article Type
Technical Solution


Issue



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.


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. Re-try backup job.

 




Article URL http://www.symantec.com/docs/TECH197099


Terms of use for this information are found in Legal Notices