TheSQLGuru (5/20/2014)

Taking another opportunity to steer the user (and every SQL...

You can buy sql server 2012 standard licenses under server/cal licensing, but these prices seem to be based on core licensing. do you need core based licensing? the only time...

What is going on in activity monitor when the agent job is running? It must be in some state, ie running or suspended. If suspended what is it waiting on?...

What if you change the backup job to backup to a new file instead of append to existing?

can you screenshot the pertinent parts of the maintenance plan and post as attachment? What do you see in SQL management studio activity monitor while the job is running? How...

Where's the love!

you mentioned there was index fragmentation, do you ever rebuild the indexes? do you update statistics? What are the server specifications in terms of memory and cpu and what are...

So this is only at certain times on certain days? At those times have you ran activity monitor to get a view on the status of the system? anything being...

Does either server use the default SQL port, if so which one? server A or Server B

Does it run at the same time every night, does it fail certain days and not others? Any extra load on the servers when the job fails?

Does it only work when you manually run the agent job, and fail when the agent job runs automatically?

So the job running from the sql agent doesn't fail every time?

Could it have been a copy only full backup that you performed?

If you are not going to restore system database make sure you record the sql server logins (windows and sql authentication) and their permissions, as these will need to be...

Do you have any downtime windows to create the clustered index offline? Could be worth a go, will use less resource.