Thanks.. I do aggree with you but the client I work for has an inhouse app (which is actually a db backed by sp and history) to standarize these jobs....

Last succesful run took around 4 hours. 🙁

I am talking with Managment to force the change

However, is there any way to trace the stress level for the server during that...

Assuming you have correct access... There may be issue with coaliation also... However I would recomend to use below steps:

1. Verify your access

2. Run sp_helpdb on the DB

Thanks Mark

Thanks a lot.. It really gave me an idea.

I will try to share my final thoughts here too 😀

This is the smallest unit where SQL Server stores data phically.

Server refer to each page to work with data.. Please refer to MS website or google SQL Server Architecture for...

Looks like some disc related issue to me (May be I am wrong),,

Can you take a full backup manually using TSQL and see what it is doing?

Also...

We are trying to make a standard here which we may share among the organazation as a standard monitoring events. It should cover all the typical issues from all areas...

Any idea plz... :rolleyes:

Both way will work

Also if you uninstall a node from a cluster, it will uninstall only that instance 🙂

Not all instance from the node

Madhu

Please follow below steps.. You will be good to go...

1. Start SQL Setup by logging in in console mode

2. Select mainteaince option

3. Select setup option to remove the node

4....

Thanks.. Is there any site which will show me the pros and cons of both the approach?

Thanks a lot

Thanks.. But is not .dmp will have dump infos from Server? Could you please tell me the reason why should I add .dmp in the monitoring systems?

Milllions of thanks to you both. It really helped me a lot..

Have a nice evening 😀

Must be some issue with DBLogin or IIS Configaration.. Did you check the error log? It should give you better understanding