Take more frequent log backup, this will prevent it from growing.

If you still want to shrink it, you can run DBCC SHRINKFILE('yourLDFfileNameGoesHere', 0). This will shrink the LDF file at...

Yes,...

I don't think it's possible.

You can clear sys.dm_os_wait_stats and sys.dm_os_latch_stats with DBCC PERF, I'm not aware of other DMVs that can be cleared without a restart.

Are you sure you're working on SQLServer 2008? With version 2005+ this should work.

Don't shrink the database. If it grows, this means it needs the space. If you shrink it, it will grow again.

If you don't want your log files to grow,...

Read this.

The description of your problem is not very detailed, so that my answer cannot be detailed either:

take a backup, upload it to the target machine.

Restore data from a good backup set. There's no "undo" command that you can issue.

If your database is in full recovery model, you can restore to a point in time...

WayneS (10/10/2010)

---

Jeff Moden (10/10/2010)

---

Heh... the lion sleeps. That...

Interesting question. I'm curious.

At last, Mr. Celko gives a polite and useful answer to a poor-worded question.

It's nice to see everyone can learn.

Really, does it? 😛

Jeff Moden (10/8/2010)

---

If you put the request for a NEXTID inside yet another transaction, especially a long winded transaction, it will occasionally deadlock (according to what we saw at the...

Hope this can make things clearer:

Introduction to the Oracle Database

PaulB-TheOneAndOnly (10/7/2010)

---

saurabh.deshpande (10/7/2010)

---

Hi Paul

Thanks for Short explanation about Oracle RAC.

...