Jeff Moden (12/4/2010)
Sachin Nandanwar (12/3/2010)
Also it is a better idea to put the recover model to SIMPLE or else your log file will bloat.But make sure you take a Full and a T log backup before changing the recovery model to SIMPLE.Agh... be careful now. Changing to SIMPLE breaks the backup chain. This is normally one of the worst things you can do.
But that's the reason I suggested to take a FULL backup before changing it to SIMPLE.Then delete the records.Change it to FULL.Again take a Full Backup.
Correct me if I am missing something.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server