Forum Replies Created

Viewing 15 posts - 22,006 through 22,020 (of 49,552 total)

  • RE: DBCC Shrink Log file in Database is read only in sql2005

    Please note: 3 year old thread. And the DB is not read-only, it's in STANDBY.

    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

    November 24, 2011 at 2:06 am

    #1412585

  • RE: Can't Shrink the Transaction Log

    Welsh Corgi (11/23/2011)

    GilaMonster (11/23/2011)

    Welsh Corgi (11/23/2011)

    GilaMonster (11/23/2011)

    There's definitely a section on what the replication wait means.

    I did not question what the replication wait means and I replied to you 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

    November 24, 2011 at 2:06 am

    #1412583

  • RE: suspect database, file backup restore

    viiki.seth (11/23/2011)

    run dbcc checkdb() prior and after the restore and compare the result.

    Other than a rather slow way of getting the row counts of all tables, I can't see how...

    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

    November 23, 2011 at 1:39 pm

    #1412467

  • RE: suspect database, file backup restore

    frankie11 (11/23/2011)

    Gail, Pardon me here, how do I know if master is up to date and correct after the restore of image?

    Is there anything that I can check to ascertain?...

    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

    November 23, 2011 at 1:38 pm

    #1412462

  • RE: Can't Shrink the Transaction Log

    Welsh Corgi (11/23/2011)

    GilaMonster (11/23/2011)

    Did you read the article?

    I read it, then I scanned it again prior to asking the question.

    Then I search for it and no matches found.

    There's definitely a...

    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

    November 23, 2011 at 1:35 pm

    #1412460

  • RE: AUTO_CLOSE reverts to ON in db created by attaching .mdf

    viiki.seth (11/23/2011)

    You also do it by changing the auto-close property to false of model DB.. so after attaching u don't need to change.

    As Lowell said:

    yep that will affect any...

    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

    November 23, 2011 at 12:06 pm

    #1412412

  • RE: Can't Shrink the Transaction Log

    Did you read the article?

    Free space with DBCC SQLPERF(LogSpace)

    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

    November 23, 2011 at 12:05 pm

    #1412410

  • RE: Can't Shrink the Transaction Log

    Is there free space in the log files? What's the log reuse wait type?

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    November 23, 2011 at 11:16 am

    #1412379

  • RE: Uniqueidentifier.

    You don't need an NVarchar for uniqueidentifier, it contains the characters A-F, 0-9 and - and is 36 characters long.

    Try this:

    SET @RulesName = 'Site: 1, RoleType: 2, Role: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx';

    SET @RulesName...

    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

    November 23, 2011 at 11:11 am

    #1412376

  • RE: Database Mirroring (Mirror a database to two locations)

    In 2008 a mirroring setup can only have one principal and one mirror. End of story.

    SQL 2012 (Denali) has AlwaysOn which allows for multiple active replicas. This is a new...

    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

    November 23, 2011 at 10:02 am

    #1412337

  • RE: suspect database, file backup restore

    ALZDBA (11/23/2011)

    What where the results your the dbcc you ran on the suspect db.

    CheckDB can't be run on a suspect database, it has to be set to emergency mode first...

    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

    November 23, 2011 at 9:58 am

    #1412335

  • RE: suspect database, file backup restore

    frankie11 (11/23/2011)

    "No, after they apply the image (which I assume contains the system DBs) then restore master only if necessary"

    - Does that mean I would not have to restore...

    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

    November 23, 2011 at 9:56 am

    #1412331

  • RE: Update Statistics and Backup

    Dev (11/23/2011)

    This cat is not lazy (curious though) but has limited tools in hand.

    You don't have a single SQL instance anywhere at hand and you don't have the...

    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

    November 23, 2011 at 9:01 am

    #1412285

  • RE: Update Statistics and Backup

    PaulB-TheOneAndOnly (11/23/2011)

    For starters why in the world would a RDBMS development team exclude on purpose performance statistics during backup? Just to add overhead during backup then add overhead during...

    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

    November 23, 2011 at 9:00 am

    #1412284

  • RE: Update Statistics and Backup

    A full backup is a complete copy of everything in that database at the point that the backup is taken. Distribution statistics are part of a database (they're hidden 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

    November 23, 2011 at 8:57 am

    #1412280

Viewing 15 posts - 22,006 through 22,020 (of 49,552 total)