Viewing 15 posts - 1 through 15 (of 17 total)
I recently switched our index rebuild scripts to use tempdb for the sort runs instead of the database containing the index. I had the same issue where the transaction log...
January 5, 2011 at 7:36 pm
Querying sys.database_files should work in either version.
January 5, 2011 at 6:31 pm
I run into this every now and then when I restore a database (that was a subscriber or publisher at the time of backup) to a new instance. I find...
July 28, 2009 at 8:09 am
The transactions that haven't been applied on the mirror database will queue up on the principal until the mirror comes back online. You can see this happening in realtime if...
July 27, 2009 at 7:24 pm
Yes. You can use sp_linkedservers to return a list of all linked servers on an instance.
More information...http://msdn.microsoft.com/en-us/library/ms189519(SQL.90).aspx
July 27, 2009 at 1:56 pm
I may have a solution to your problem. Since you still need the dependence on Job A for Job B to start you won't be able to do this using...
July 23, 2009 at 12:47 pm
Golden,
You can't do both. You can start Job B (with no schedule) on completion of Job A OR you can have a schedule assigned to Job B that allows it...
July 23, 2009 at 10:19 am
Performing a transaction log backup in the full recovery model truncates the log, allowing the space to be reused for new transacions. You will "get everything" in your log backup...
July 22, 2009 at 7:00 pm
What's the actual error message?
July 22, 2009 at 6:53 pm
It means that if the if Job B is bound to the completion of Job A, even we set the schedule inside job B, will it cause a failure?
You can...
July 22, 2009 at 12:31 pm
Right. The way I understand it, setting a stop criteria in a job schedule for 11:59 can only be done if you specify a frequency for the job to run...
July 22, 2009 at 9:12 am
It looks like you've already identified the issue causing the error. The workaround is to shrink the log file so the scan finishes within the 10 second window or to...
July 22, 2009 at 6:34 am
golden (7/21/2009)
The situation is as below, I would like to schedule the SQL jobs to run 3 steps
(1) Step 1 run for just one time starting from 8am,once...
July 21, 2009 at 8:02 pm
What actually "blew up" with respect to the replication? I would suspect you either had storage or network latency issues that resulted in an apparent failure (network) or actual failure...
July 21, 2009 at 12:26 pm
From msdn...
char [ ( n ) ]
Fixed-length, non-Unicode character data with a length of n bytes. n must be a value from 1 through 8,000. The storage size is...
June 8, 2009 at 10:22 am
Viewing 15 posts - 1 through 15 (of 17 total)