Put on blackbox trace - This is free just need to run the sql procedures at least your see what was running at the time it does not connect.

It will...

If you clean buffers and just do open database and see the list of tables ...upon doing this they go to buffer memory and stay there that seems strange to...

sp_helprevlogin is the script...if i recall the name correctly

Thanks, I will start to investigate the IO and waits. San results look good no issues there but could be the SQL Server IO pushing to the SAN.

You could run few queries with IO Stats on them and show them it takes x seconds to run without up-to-date indexes and x seconds with them.

Also explain to them...

That looks good i will look at this and work with it. Thank you for taking the time to review.

sp_configure or right click sql server name properties to change default memory settings. Not looking at SQL but i am sure that the place.

whats the version of SQL Server...

The master databases from 2005 and 2008 are difference, i am not sure you want to restore this datbases master for 2005, all other databases other than system are fine....

The last part at the end wasn't of much use for the users just the Error detail so left that in there.

Worked on my small sample of data, now running on my hugh output.

Thank you for your time and supplying code.

CREATE TABLE [dbo].[TABLE1](

[ID] [nvarchar](22) NOT NULL,

[CONTEXT] [nvarchar](30) NOT NULL,

[VALUE_ID] [nvarchar](22) NOT NULL,

[PROCESS_ID] [nvarchar](59) NOT NULL,

[DATA] [text] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

ID = '1'

CONTEXT = 'Project'

VALUE_ID = '1000'

PROCESS_ID = 'Check'

DATA =...

With this information would you be able to replicate the data to another database. Most of the software we use does not have primary keys so SQL Replication is...

Yes that is what the mail does it starts then when no emails to fire shutdowns when a mail is sent it will restart up. Nothing to worry about.

http://www.sqlservercentral.com/Forums/Topic162137-5-1.aspx

If this is a brand new sql server you just up i would uninstall and reinstall just to be safe from anything not working...but you can do it...

All of our SQL Servers are on VM.. Advantages can build a new VM Sql in a matter of minutes..you build templates for sql on VM and install VM in...