It matters, but not for the reason you are asking.

Although they are not required in your restore scenario, most back-up/recovery strategies would have T-log backups conducted on a more frequent...

Trace flag 1222 became available in SQL 2005, and is a lot easier to read than 1204.

You will want to run just trace flag 1222. Since there will be...

Thank you for your response Vedran,

I was somewhat aware of the issue over 4GB increments, and will consider this next time I manually grow a log file. But at...

SQL Server 2005 or 2008? What version/service pack are you running... select @@version.

Add hoc workloads, maxdop and auto-update statistics (not), are a few of the configuration settings that come to mind when looking into optimizing a SQL Server for running SharePoint.

One of...

Thank you Gail, I will surely look into that.

Fingers crossed, the error still has not recurred, but I will be looking out for it. When I get back to...

If you forgo the "with copy_only" option and decide to have the offsite backups be copied from your already existing backups you could use SSIS, robocopy, etc.

SSIS packages are good...

I feel for you. We run several SharePoint sites and it has been more difficult to find definitive answers regarding SQL database configuration, troubleshooting, etc. than with non-SharePoint databases.

That...

This is xml data. You are attempting to do a string comparison by using LIKE, and it expects a text data type. Try looking at how to perform this...

Great advice (ebook)...

But first, just be absolutely sure your cpu isn't being consumed by the os before deep diving into wait stats, etc. I know you said...

Check the file extension you set up for the maintenance cleanup task. It needs to be set as "bak" without the dot (.bak).

Your SQL Server installation DTS packages directory. Here is one example of a natural location for SSIS packages: C:\Program Files\Microsoft SQL Server\100\DTS\Packages.

If you are using a maintenance plan, look closely at the t-sql statement(s) it created. The maintenance plan interface does not always display all of the databases being backed up...

Try this. Given at least 1000 records exist in tblTest, this would insert 1000 rows into temporary table tblTemp.

SELECT column1 INTO #tblTemp

FROM tblTest

WHERE column1 IN

(SELECT TOP 1000 [col1]

FROM...

You might want to make sure you are writing execution trace history to SQL Server Agent. This can give you some additional logging for troubleshooting purposes. Do this in...