How to recover the dumped SQL Server dump

[manohars]

In the production floor, database server dumped. When we put a big transaction, it didn't complete, though it was tried repeatedly. After a while, when SQL Server service is restarted, the same transaction worked perfectly. What could be reason for this.

Thanks in Advance,
Manohar

 

[SQLBill]

Almost anything. There's really not enough information for us to help you on this.

Some possibilities:

1. To many other processes running
2. Another transaction 'locking' the tables your transaction needed to use (Deadlocking)
3. To many concurrent connections

Check your SQL Server Error Logs for any messages that might shed light on this.
Check the Windows Event Viewer Logs (Application, Security, System) for any messages that might shed light on this.

Were you running this as a JOB? If so, find the job, right click on it and select View Job History.

-SQLBill

Posting advice: FAQ481-4875