Viewing 15 posts - 1 through 15 (of 50 total)
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...
November 25, 2013 at 7:44 am
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...
March 20, 2013 at 7:28 am
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...
February 16, 2013 at 6:36 am
SQL Server 2005 or 2008? What version/service pack are you running... select @@version.
February 12, 2013 at 7:06 am
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.
February 10, 2013 at 2:10 pm
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...
February 10, 2013 at 1:41 pm
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...
February 10, 2013 at 10:03 am
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.
February 9, 2013 at 8:53 am
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...
February 5, 2013 at 7:15 am
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...
January 28, 2013 at 7:09 am
Check the file extension you set up for the maintenance cleanup task. It needs to be set as "bak" without the dot (.bak).
January 14, 2013 at 6:52 am
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.
October 8, 2012 at 5:36 pm
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...
October 2, 2012 at 7:04 am
Try this. Given at least 1000 records exist in tblTest, this would insert 1000 rows into temporary table tblTemp.
SELECT column1 INTO #tblTemp
WHERE column1 IN
(SELECT TOP 1000 [col1]
September 28, 2012 at 2:47 pm
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...
September 28, 2012 at 10:38 am