You could contact the backup software company. Perhaps they have "retry" settings that will help if there is contention or network problems.

How about you give your answer, then the experts here can have a discussion point.

sreenubabu.s (3/12/2014)

---

Some one restarted by Windows Server 2008. On which SQL Server has installed.

can any one tell me how to find who restarted the server ant what time ?

i did...

I only went part way because I often test things a step at a time to cut down the variables if I made a mistake somewhere along the line. ...

According to my faulty memory, part of the setup process was using local SQL login accounts that had the same name & password on both servers, not Windows accounts.

Just 1 tempdb file. I recall reading conflicting opinions, so I left it at 1.

To clarify, I do see the other processors working sometimes, but was surprised this time to...

Bad News: Not much memory

Good News: Approval to upgrade all our servers...

I can only answer a couple of those right now.

MAXDOP is 0, and Cost Threshold for Parallelism is 5. There was no blocking, but I know there was a long...

Perhaps you could declare a variable as DECIMAL(10,2) then set the INT column to the value in the decimal variable... a 2 step conversion.

Thanks

How big is the log file ??

How much free space in the database ?

No other backups running at the time. I can see backup history and the 2 that did run took 4 minutes just after midnight, which is normal. Combined, the...

I ran the select by itself when troubleshooting a few hours later & it worked fine. The next day, the job ran fine again as it has for more than...

Not quite sure what you're asking

Select * into Table_A from Table_B

Did you try my reply in your cross-post ? (which is generally frowned upon)

http://www.sqlservercentral.com/Forums/Topic1538824-392-1.aspx