SQL Server – Number of Error Log Files

  Background Trying to review error logs on one of our SQL Server Instances and discovered that it is likely that the error logs we might have to mine is so far back and we might no longer have it. And, so took to see if we have properly calibrated the Number of Error Logs Files … Continue reading SQL Server – Number of Error Log Files

MSSQL Server – Database Recovery [Manual] (after a crash) – MS SQL Server v2005 and above

  Tried out Paul Randal’s database recovery steps (http://www.sqlskills.com/blogs/paul/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx)  and it works a charm --- Note that the database server will try to and most like recover itself.  But, in our case, the time for a successful recovery was too much and so we chose to 'circumvent’ possible recovery by renaming the database log files. … Continue reading MSSQL Server – Database Recovery [Manual] (after a crash) – MS SQL Server v2005 and above