Forum Replies Created

Viewing 15 posts - 14,851 through 14,865 (of 49,552 total)

  • RE: Restore db with standby

    I would guess what they mean is that if you're restoring log backups to get to just before some disaster (like a dropped table), you can restore with standby, query...

    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

    January 11, 2013 at 5:23 am

    #1576209

  • RE: I just became Keeper of the Ring. And I'm Boromir.

    You can use SSMS on your workstation. Personally I don't feel that user apps should be installed on a server.

    (no, it can't be downloaded, you'd install SSMS from the SQL...

    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

    January 11, 2013 at 5:22 am

    #1576208

  • RE: Restore db with standby

    zi (1/11/2013)

    Thanks for replying

    what about "for inspection" usage

    what do you mean by 'inspection usage'?

    , how to apply it,

    How to apply what?

    and what is the standby file, how to...

    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

    January 11, 2013 at 4:19 am

    #1576176

  • RE: Database in Recovery

    SQLSACT (1/11/2013)

    GilaMonster (1/11/2013)

    Yes, you could have. The DB was online and available.

    Thanks, would you recommend it though?

    Yes, why not?

    Am I right in that the 3rd phase (Undo) is where...

    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

    January 11, 2013 at 4:18 am

    #1576174

  • RE: Restore db with standby

    Typically used in log shipping when you want the secondary to be readable (restore with norecovery is not) and still allow further logs to be restored.

    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

    January 11, 2013 at 4:06 am

    #1576165

  • RE: Database in Recovery

    Yes, you could have. The DB was online and available.

    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

    January 11, 2013 at 4:05 am

    #1576164

  • RE: SQL Server consuming 90% Memory

    The max server memory setting controls the buffer pool. That's all of the caches (buffer pool, plan cache, etc) plus the query workspace memory. SQL can and does take memory...

    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

    January 11, 2013 at 3:30 am

    #1576152

  • RE: I just became Keeper of the Ring. And I'm Boromir.

    That's a UPS, not a storage device.

    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

    January 10, 2013 at 12:54 pm

    #1575945

  • RE: How To Recover Unused Space From Data File

    YSLGuru (1/10/2013)

    Is it possible duing the restore to restore the DB so that it have a small amount of room to grow and not the full amount that the live...

    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

    January 10, 2013 at 12:54 pm

    #1575943

  • RE: I just became Keeper of the Ring. And I'm Boromir.

    If you're talking about a RAID array write cache backup battery, then you either must replace it or must disable the write cache or you are risking a corrupt database.

    Start...

    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

    January 10, 2013 at 12:22 pm

    #1575931

  • RE: Objects with High buffer pages

    High memory usage from SQL is a good thing. SQL uses memory to cache data and to cache plans. Both of those allow for better performance than if it didn't...

    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

    January 10, 2013 at 12:17 pm

    #1575926

  • RE: How To Recover Unused Space From Data File

    DBCC ShrinkFile or DBCC ShrinkDatabase.

    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

    January 10, 2013 at 11:56 am

    #1575920

  • RE: Objects with High buffer pages

    Well... the next step would be to figure out whether high buffer page usage by that object is a problem or not. If it's a large table that's frequently read,...

    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

    January 10, 2013 at 11:56 am

    #1575918

  • RE: HOLDLOCK along with UPDLOCK

    The update lock is held until the transaction commits or rolls back.

    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

    January 10, 2013 at 11:53 am

    #1575916

  • RE: table partitioning

    yes, providing all the tables have the same column. Not sure it's necessarily a good idea, but you can do it.

    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

    January 10, 2013 at 11:52 am

    #1575915

Viewing 15 posts - 14,851 through 14,865 (of 49,552 total)