It makes a difference in how you can recover. If recovery mode is 'simple' than a backup before the truncate is not needed at all, just after the truncation to...

opinions are like a$$holes in a number of ways ... first everyone has one, second some are bigger than than others ... need I say more based on the source of...

We've had a couple of IBM E-Series 445 clusters with RAID and SAN storage. You might want to check the driver levels on your servers. DO NOT USE Windows Update....

Prior to SQL Server 2005 (v4.21, v6.0, v6.5, v7.0 & SQL2000) there were no imposed limitations on the length and complexity of 'standard' security regarding SQL Server login passwords. However...

If it were my database I'd go through and change the names of all of the offending columns. One never knows when SQL will serve up an 'undocumented feature' (bug)...

No one mentioned anything about 'recovery mode' ...

It sounds like a corrupt file to me ...

Based on 2 points in your initial problem:

"... the snapshot file of 970 MB. it will take 5 to 6 hrs ..."

I'd also look into the network performance and throughput....

If you did not get an error message within SQL Server then your next step would be to contact your email admin. depending on your email system there are various...

Could you post the error message ?

You may want to take a look at the application that uses the databas. Maybe there are administrative functions within the application (we just found one that did DBREINDEX and...

The 'paranoid' DBA in me now comes to light ... To be on the safe side I always perform a full backup every time I switch recovery modes ... Backup...

Now I see said the blind man ...

My response to STFU is BFD ...

big furry dog ...

"STFU" ??? Please translate ...

I believe that the answer to this question lies in your own 'perspective'. Have I ever failed on a project - NO. Have I been a part of projects that...