Sorry, but IndexID 1 is the clustered index, not a nonclustered index....

Is there a lot of update/insert/delete activity on this table? Very good possibility that space is not being reused and more space is allocated when it thinks it...

Welsh Corgi (6/26/2012)

---

I tried BOL but I must not have entered the right search criteria.

Then I goggled it and got a article that provided the example that I listed in...

I don't consider any backup unnecessary, regardless of data changes or not. As a DBA at a previous employer, both the model and master databases were backed up daily....

This may also be useful.

http://msdn.microsoft.com/en-us/library/ms187997.aspx

Curious, have you looked in BOL?

http://msdn.microsoft.com/en-us/library/ms175081.aspx

Depends on what's wrong and how they need to be changed. Just from your vague description, not a clue on how I would proceed.

TheSQLGuru (6/26/2012)

---

Lynn Pettis (6/26/2012)

---

ScottPletcher (6/26/2012)

---

You lose the db as it exists if a RAID1 fails, but if you place the files properly on the two RAID1s, the db can be...

sturner (6/26/2012)

---

GSquared (6/26/2012)

---

Shall I continue? Or just read the Constitution and you'll see a list of the critical services and enforcement needs. It's very finite, though subject to...

ScottPletcher (6/26/2012)

---

You lose the db as it exists if a RAID1 fails, but if you place the files properly on the two RAID1s, the db can be fully recovered, which...

Can't help with the problem, but I would say it would help if you also put the full error message in your post.

Not a lot to work with. Have you checked your SQL Server logs for additional error messages that may help?

TheSQLGuru (6/26/2012)

---

ScottPletcher (6/26/2012)

---

OK, but it's not the odds against losing...

System would insert the record into the existing page. SQL Server won't create a new page just because you are 75% full on the page. If the record...

J Good (6/26/2012)

---

Thanks everyone - all good advice.

One of the issues we face is that we only have a 1Gbit network connection for our backup servers. It can take...