Patrick Womack (11/5/2007)

---

I have a monthly maintenance plan that performs several steps on my user databases only.

Should I also have a maintenance plan for the system databases? If so,...

Rohit Chitre (11/5/2007)

---

Hi ,

I have a database where I will be updating 500,000 daily rows in recent future. Is there anyway (other than truncating the log later) that can be...

Ben Curry (10/29/2007)

---

We have a PRD db on our SAP Production server and a PRD db on our SAP Production Disaster Recovery server.

We employ log shipping to keep the DR...

SQLBill (3/21/2006)

---

To use Truncate or not........

If you use truncate (with DBCC SHRINKFILE or with BACKUP LOG dbname WITH TRUNCATE_ONLY), you 'break' the backup chain and must start a new chain....