How often? Is it succeeding?

It's possible that the error came about when the log had to grow and the grow took too long. What's the auto-grow settings on the log...

And even with a 3rd party tool, there's no way to edit a tran log backup.

Anyone who decides to use this should note two things.

1) The backup log with truncate will break the log chain. Hence an immediate...

I'll take a look when I get a few min.

Do you have transaction log backups?

There is absolutely no reason to have multiple log files. It gains you nothing. Log files are written in sequence, not in parallel. The only reason to have more than...

All of the 2008 exams are out of beta. Hence there's no way for you to...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic643933-338-1.aspx

Make sure there's no shrink operation running, autoshrink or a scheduled shrink.

serge.kovacs (1/26/2009)

---

Maybe I wasn't clear on the inner workings of the application on start-up. It will load all data from all tables so there should be no need to use...

Please don't shout (type in all caps). It's not going to make someone help you faster. If I may suggest,...

Can you ask then to substantiate the statement? Either prove it with an exec plan (where a covering...

madhu.arda (1/26/2009)

---

How this will effect sharepoint databases? if anything happens, will MS support us? and they said rebuild index task is corrected in SP2, that means if we have SP2...

I just wanted to emphasise the fragmented indexes that it would cause.

Since the PK column is not declared as identity, you'll need to specify the values for the ID column. That's what it's complaining about, not the 'John Doe' name.

As the...