troubleshooting Question

SQL 2005 Cleaning up

Avatar of dastaub
dastaubFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
8 Comments1 Solution339 ViewsLast Modified:
1.) I have a 20 billion byte table in SQL 2005.  I will be deleting about 1/3 of the rows in the table.  When I perform these deletions, can i temporarily stop from writing to the log file by setting the backup to SIMPLE or if I do this am i asking for trouble by switching from FULL to SIMPLE and back again to FULL.  I assume I should do a full backup, switch to SIMPLE, perform my deletions, then switch back to FULL backup?

2. ) What gets written to the Log file when you delete an index from a table?

3.) I was told to delete non clustered indexes first, then the clustered index?
ASKER CERTIFIED SOLUTION
simonet

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros