Viewing 15 posts - 33,316 through 33,330 (of 49,552 total)
Sorry, I don't understand the question. What is it that you're looking for?
March 27, 2010 at 8:35 am
With replication the log reader reads through the tran log looking for transactions that are marked 'for replication'. When it finds those, it sends them to the distributor where they...
March 27, 2010 at 8:33 am
Then there's something else causing the job to fail. Set the job to write output to a file and check that for the complete output.
March 27, 2010 at 2:36 am
Please run the following on all of the database that the integrity task runs against and post any results.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
March 26, 2010 at 1:02 pm
jcrawf02 (3/26/2010)
I guess your server names just depend which TV show/movie you're a fan of.
Myrlin, Camelot and Excalibur here, though those are my personal machines, not work servers
March 26, 2010 at 12:54 pm
Danky 7 (3/26/2010)
and almost works fine, just the databases over the secondary server stay on status Restoring.Any idea why about that?
They will. That's how log shipping works.
The database on...
March 26, 2010 at 10:34 am
blue_inelush (3/26/2010)
I dont' know if possible, because I have nerver tested them, but have you tried:1. to update the db files status in the sys.database_files?
Cannot be done. Very, very dangerous...
March 26, 2010 at 2:23 am
SPID -2 is related to DTC. Spid -3 is not. (and neither is -1)
Spid -3 is a deferred rollback. In 2005/2008 Enterprise edition, SQL will bring a database online at...
March 26, 2010 at 2:21 am
Transaction log replication? Do you mean transactional replication?
March 26, 2010 at 2:00 am
charipg (3/26/2010)
There is no eventlog and sqlserver errorlog for this .
Can you post the SQL error log and let us have a look at it? There may be messages in...
March 26, 2010 at 1:56 am
The Dixie Flatline (3/25/2010)
ARID = Alternate Reality ID.I believe it's parameter 117, but I'd have to confirm that with Gail.
From what I recall, it's 117 if...
March 25, 2010 at 11:55 am
Each post gets you 1 point. Correctly answering the QotD gets you points. Currently that's all.
March 25, 2010 at 10:05 am
Lynn Pettis (3/25/2010)
Is it me or is she always such a negative nellie?
It's not you.
Remember the discussions on women in IT and how she reacts in those. There's a reason...
March 25, 2010 at 9:09 am
Alvin Ramard (3/25/2010)
I read that last night and I just commentrd on his comment.
her comment
March 25, 2010 at 8:01 am
I had a bout of this late last year. Came to a head late October/early November. Not over it yet, better but still got the 'don't care about anything' feeling.
March 25, 2010 at 7:13 am
Viewing 15 posts - 33,316 through 33,330 (of 49,552 total)