Same problem here too. Sometimes it changes to 24 minutes, so I have to change it a 2nd time to get it to "stick".

I suppose you could set up...

Yes, removing the alias works, but it seems strange that it is not valid code. Upgrade Advisor won't work because we have Cold Fusion and PHP code outside of SQL.

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