David Benoit (5/12/2009)

---

Just a thought too, but while the DBCC continues you might want to start looking at backups and ensuring that you have one available and ready to go...

Krishna,

Have you done this specifically with Sharepoint? Log shipping isn't my forte, so I am curious how it would work for a product like Sharepoint where the Service account...

I'd agree with Markus, from a licensing standpoint no, but your best bet would be to contact Microsoft Licensing directly:

In the US, call (800) 426-9400.

In Canada, call (877) 568-2495.

Per the Book Online, that wait type signals the following:

Occurs when the pushing or pulling of a page to a snapshot (or a temporary snapshot created by DBCC) sparse file...

Go with 2008. The improvements and enhancements to manageability in 2008 alone make it worth upgrading to.

Unless you are normally running CHECKDB (a recommended practice to catch these problems early on and reduce downtime/risk of data loss) and can look at the historical runs for how...

The default configuration for SQL Server should be used unless you have a demonstrated problem that requires a different configuration. This is to include the Max Degrees of Parallelism...

I would think that Step 4 would be done before Step 3, but I could be wrong. If the databases are owned by one of the logins in Step...

I would agree that this points to a physical disk problem on your server. Your only recourse may be to recover from your previous backup at this point. ...

Kendal,

Your best bet will likely be to capture the information from the DMV's as listed in the following Whitepaper:

http://technet.microsoft.com/en-us/library/cc966545.aspx#EEAA

Don't forget that you can also have SELECT * INTO #TempTable and Worktables created by the...

Suresh,

Glad it could help. If you have the available means, moving logs separate from data is definately a thing to do. If it means laying out more money...

I agree with Grant on this point. You...

Make sure that you take good note of this, because this actually runs on a background connection to the database that will...

What kind of backups are being done, and what are the recovery models of the databases that succeed , and for the model database as well?