Forum Replies Created

Viewing 15 posts - 33,316 through 33,330 (of 49,552 total)

  • RE: Process blocked

    Sorry, I don't understand the question. What is it that you're looking for?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 27, 2010 at 8:35 am

    #1140937

  • RE: Transaction log shipping and transaction log replication

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 27, 2010 at 8:33 am

    #1140936

  • RE: dbintegrity

    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.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 27, 2010 at 2:36 am

    #1140911

  • RE: dbintegrity

    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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 26, 2010 at 1:02 pm

    #1140682

  • RE: Are the posted questions getting worse?

    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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 26, 2010 at 12:54 pm

    #1140678

  • RE: Log Shipping: Over Server B DBs stay on Restoring

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 26, 2010 at 10:34 am

    #1140534

  • RE: Database is in recovery status.

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 26, 2010 at 2:23 am

    #1140188

  • RE: Strange problem with negative transaction

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 26, 2010 at 2:21 am

    #1140186

  • RE: Transaction log shipping and transaction log replication

    Transaction log replication? Do you mean transactional replication?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 26, 2010 at 2:00 am

    #1140174

  • RE: Database is in recovery status.

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 26, 2010 at 1:56 am

    #1140173

  • RE: Are the posted questions getting worse?

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 25, 2010 at 11:55 am

    #1139890

  • RE: How to Play the SSC Game - SSC Points

    Each post gets you 1 point. Correctly answering the QotD gets you points. Currently that's all.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 25, 2010 at 10:05 am

    #1139770

  • RE: Are the posted questions getting worse?

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 25, 2010 at 9:09 am

    #1139713

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/25/2010)

    I read that last night and I just commentrd on his comment.

    her comment

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 25, 2010 at 8:01 am

    #1139649

  • RE: Burnout

    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.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 25, 2010 at 7:13 am

    #1139601

Viewing 15 posts - 33,316 through 33,330 (of 49,552 total)