mark (3/29/2009)

---

Hi,

If we have that many log files being written to, won't this as a result turn into mainly random writes, instead of sequential?

john (3/29/2009)

---

I want to use the SQL Management Studio to schedule automatic backups of the database

TRACEY (3/28/2009)

---

Also set up permon on disk/cpu etc and measure this through slow periods and busy times.

Erode P. Satheesh (3/24/2009)

---

Take a full backup.

klnsuddu (3/24/2009)

---

Hello,

We have our backup strategy as below:

1. Full backup dailly at 1:00AM

2.Diffrential every 4 hrs starting from 5:00AM

3.Log backup every 1 hr starting from 2:00AM

Michael Valentine Jones (3/28/2009)

---

I Also, the benchmark results should be saved so that you can compare to them later if you suspect IO problems.

Elliott Berkihiser (3/27/2009)

---

The error message reports "Cannot create a new Service Broker in a mirrored database". I tried pausing the mirroring and received the same message.

GilaMonster (3/27/2009)

---

Krishna (3/27/2009)

---

1.) There should be at least one clustered index for a table which should be Narrow, ever-increasing, unique

At least one?

Vera (3/27/2009)

---

DBCC SQLPERF (logspace): logsize: 74.929688logspace used: 83.246666