yep and I don't mind if I am getting dirty data.

Hi,

There isn't any blocking nor fragmentation which is what I'm slightly confused by. The app team was also confused by this. We do use a third party software...

Hi,

Are you able to assist of how I can customise your script to get the same results for 2008?

Thanks

Hi Gail,

I've had a look at the logs and there isn't much. Trawling through the windows logs as well it seems that sql could have been accidentally stopped by...

Gail,

The time at which the issue happened looking at the event viewer doesn't seem to make any sense to me.

The last few lines are

recovery of database MNR is...

Gail,

Sorry the last 3 entries were

1) [360] Sql server agent initiating shutdown following mssqlserver shutdown

2) [359] Local host server is not running

3) [098] sql server agent terminated (normally)

Hi,

Thanks for all your replies. I have checked event logs and I couldn't find anything conclusive. In the application area, I found that sql server agent service successfully...

Thanks

Yep, already tried all of that.

Default instance. I was able to connect both locally and remotely.

I would assume perhaps firewall may be causing this issue