Michael Valentine Jones (5/3/2011)

---

Raymond van Laake (5/3/2011)

---

Hi,

I would appreciate any feedback on my backup strategy. I also have a question or three. Note that there is little or no activity...

SQLRNNR (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

GilaMonster (5/3/2011)

---

Just to pile on, an untested backup strategy is not a backup strategy. It's a backup desperate hope.

I've seen someone cause 4 hours additional downtime during a...

Completely forgot about that one... and likely your best shot at this point.

A similar issue is that the server is experiencing a lot (A LOT) of recompiles. Not using...

GilaMonster (5/3/2011)

---

Just to pile on, an untested backup strategy is not a backup strategy. It's a backup desperate hope.

I've seen someone cause 4 hours additional downtime during a disaster because...

It'll get you there... eventually.

The best option was copy / truncate, reimport but that table must see way too much action to get this to work.

I'd go the safe route,...

Why are you not allowed to use subreports?

Makes no sense. Normally you could get a few plans for different connection settings but this is ridiculous.

Are use sure those are called via RPC and not via adhoc?

Do...

http://www.hatimalsum.com/2010/05/18/sql-server-2008-enable-xp_cmdshell/

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/71873369-f987-4256-83db-eece2734bda4/

SQLRNNR (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

SQLRNNR (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

SQLRNNR (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

And now the moment is gone......

Then use the 3rd table (articles).

You can also do this in 2-3 steps (avg on tbl1, avg on tbl2, then join on article and scan for what you need)

I'd start a look and delete by batches of maybe 10 000 ended sessions (or whatever runs under 0.5 seconds).

wait 2-3 seconds for the server to catch up and affect...

SQLRNNR (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

SQLRNNR (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

And now the moment is gone... 1 too...

GilaMonster (5/3/2011)

---

Syed Jahanzaib Bin hassan (5/3/2011)

---

you can use this command on SQL Server 2008 and 2008 R2 also,if you want to truncate the file just add new log file and...

Ninja's_RGR'us (5/3/2011)

---

SQLRNNR (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

And now the moment is gone... 1 too many post...

SQLRNNR (5/3/2011)

---

WayneS (5/3/2011)

---

+10!

Yes, please do...