parthi-1705 (3/17/2010)

---

I am having a 30 million records i need to delete 25 million old records with minimum log how it can be done there will be continues users accessing the table

Brandie Tarvin (3/17/2010)

---

Understand that minimum logging is different than "no" logging. You might want to change the Recovery mode to Bulk-Logged instead of Simple (unless the db is already set to Simple) before doing your delete. This way, if you need to recover, you'll still have a transaction log to recover from.

vidya_pande (3/17/2010)

---

I have simple solution for you.

Copy 5 Million records to another dummy or staging table.
Truncate the original table.
And then copy 5 Million rows from Dummy table to original table.

If you do not have partitions created on table this is the fastest way.

vidya_pande (3/17/2010)

---

I have simple solution for you.

Copy 5 Million records to another dummy or staging table.
Truncate the original table.
And then copy 5 Million rows from Dummy table to original table.

If you do not have partitions created on table this is the fastest way.

hp_dba_uk (9/24/2012)

---

Hi there,

I used a script to changed around 60 cust-test DBs from Full to simple recovery model as they were not needed to be in Full recovery mode etc

I did the change on Fri and today is Monday..I was expecting the see lot of space freed up on the drive where files are stored, by this as thinking it will run checkpoint etc....but below reasons tells me it wont happen straight away:
================
If the database is using the simple recovery model, an automatic checkpoint is generated whenever the number of log records reaches the lesser of these two values:

The log becomes 70 percent full.

The number of log records reaches the number the Database Engine estimates it can process during the time specified in the recovery interval option.
=================


Some of these DBs have never been backed up but were in Full recovery model. So does this change anything?
or is it a simple matter of watining?