Tag Archives: sql server

Loss of Files Does Not a Suspect Database Make

Posted on July 8, 2010 by way0utwest

I saw a post recently by someone asking how to get a database to be suspect. They said they had added a data file and then remove it, but the database wasn’t suspect. This was true in the past (v6.x), … Continue reading →

Posted in Blog | Tagged , | Comments Off on Loss of Files Does Not a Suspect Database Make

Truncating the Log and Database Mirroring

Posted on June 30, 2010 by way0utwest

I saw someone post recently that they wanted to run this code on their principal server in database mirroring to clean out a large transaction log and shrink it. alter database <mydb> set recovery simplegocheckpointgoalter database <mydb> set recovery fullgobackup … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Truncating the Log and Database Mirroring

The last good date for your database

Posted on September 24, 2009 by way0utwest

I was reading the most recent issue of TechNet from Microsoft one morning and flipped through the column on SQL Server. This is one of the few paper magazines I get, and for some reason I see things in there … Continue reading →

Posted in Blog | Tagged | Comments Off on The last good date for your database