No I never did find the exact problem that caused this.   Since it was not mission critical and that server was retired for end of life, I decided to...

I use  use the login_time from sysprocesses for spid 1 to get the restart time.  Either should work though.  The only thing that may or may not affect  you is...

Not sure if there is a more elegant solution, but here is my solution.  I  gather perfcounters every 10 minutes from my 25 production servers and store them in a non production box for analysis. ...

I do something like this usually to avoid cursors. 

 DECLARE  @TempTable TABLE

  (

 ID int IDENTITY (1, 1) NOT NULL,

 SomeData varchar(20),

 SomeMoredata int NULL

  )

-- dump all params for sproc...

I would think that Peter is on to your main problem.   The startup account for your SQL Server.  Check to make sure that the logon tab under services\mssqlserver is not...

Not sure if this helps, but I have something similar.  Weekly I have run a dts package that I FTP to another site.  I have it run as a scheduled job with...

I also had an issue fairly recently with torn page in a DB.  Usually they are a result of a hardware failure, such as the hard drive array controller in...

As Le Rhun said, sometimes just shrinking alone is not good enough.  The shrink can not shrink sections of the transaction log that are marked active.  For my pesky databases that have...

Create a job in SQL Agent.  For the step that is to run this script, choose  "ActiveX Script" as the Type and then select the radio button  "Visual Basic Script" as...

I think I grabbed this script from Script Library here, but in any case, I run this little ActiveX script weekly on each server.  I would hate having to recreate...

You may also want to check the error logs. The last time I had a suspect database was after a server crash. There was a partial write causing a...