Viewing 15 posts - 1 through 15 (of 21 total)
The server in question does not have any snapshots or hidden DBs. The DBCC task that runs prior to this looks for databases that are offline or unavailable. ...
October 1, 2012 at 9:16 am
Jeff,
The script runs fine outside of the scheduled task when coupled with the DBCC. I find it extremely hard to believe that this is the cause.
Thanks
October 1, 2012 at 8:44 am
Sorry, I forgot the version information. The servers where this is occurring is 2008 SP3 and also on 2008 R2 SP1.
thanks
September 30, 2012 at 12:29 pm
Hi there,
The backup is performed using an Execute T-SQL task. We wrote the code, tested it in SSMS and it performed without flaws. When the Backup task follows...
September 30, 2012 at 12:22 pm
Hi Lisa,
That is a long shot, but the job completes when run by itself. When the prior task is a long running one, the Backup job only gets through...
September 29, 2012 at 8:36 am
Will do! Thanks again
September 27, 2012 at 3:59 pm
The strange thing is that all of the tasks execute cleanly. There are no errors in the logs. We test all of the code in SSMS before inserting...
September 27, 2012 at 3:34 pm
Thanks for the answer.
The DBCC Task executes for a little more than 3 hours, then it moves on to the Backup task. It will execute for roughly 7 minutes...
September 27, 2012 at 3:17 pm
Do you have any other processes that are connecting into SQL Server that has the SA role. One thing you can to is disable the logins for any other...
December 2, 2011 at 6:52 pm
Hi Marcus,
When trying to feed in dynamic Linked Servers you need to create a statement then execute that.
declare @LinkedServer varchar(50), @sSQL varchar(200)
set @LinkedServer = 'Server1';
set @sSQL = 'select * from...
July 5, 2011 at 11:40 am
Timberwood,
We are currently using the MSAccess / SQL Server configuration that you are using. We have approximately 330 users with about 30 users connected at one time. These Access dbs...
May 3, 2004 at 6:53 am
Jeff,
From Wednesday's question of the Day here on SQLServerCentral, I tried the SET Timeout_Lock 60000. This seems to allow the users to run the report. But this does not explain...
March 26, 2004 at 4:50 am
Data on each server is replicated on Sat. Nights. So what is on the Prod Server is on the Dev server. The replication is done with a DTS package that...
March 23, 2004 at 5:33 am
Forgive my ignorance but is this the way you create a text based execution plan?
SET SHOWPLAN_TExt on
SET STATISTICS PROFILE ON
Exec dbo.qryLocalBoardAgendaDev1 'tblSARConfiguration.pdt = ''lccp'''
Thanks
March 22, 2004 at 1:58 pm
Thanks for the help, I will try the reindexing. I tried to see what the differences were between the tables that are being used within the query, but the indexes...
March 22, 2004 at 1:21 pm
Viewing 15 posts - 1 through 15 (of 21 total)