Forum Replies Created

Viewing 15 posts - 21,961 through 21,975 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/1/2011)

    I need to try clonezilla.

    It's a lovely tool. I used it a while back to replace a boot drive with a much larger drive. Cloned the old drive onto...

    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

    December 1, 2011 at 10:06 am

    #1415399

  • RE: SQL Server has encountered 1 occurrence(s) of cachestore flush

    Probably. Those indicate that the IO subsystem is under strain. Could be that it's just not got the throughput needed or could be there's something else running as well (file...

    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

    December 1, 2011 at 9:55 am

    #1415385

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/1/2011)

    Wouldn't that just suck. You don't still have the drive by chance?

    I do still have it. Once I get the server installed I'll stick it in there 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

    December 1, 2011 at 9:49 am

    #1415379

  • RE: Are the posted questions getting worse?

    GSquared (12/1/2011)

    Gail, while I'm gone can you keep an eye on database corruption forums and related material? Oh, and can you do the same while I'm here, too? ...

    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

    December 1, 2011 at 9:26 am

    #1415353

  • RE: DBCC DBREINDEX failure question

    Unless you ran them in an explicit transaction, the ones before would have been rebuild, the ones after not.

    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

    December 1, 2011 at 9:22 am

    #1415350

  • RE: SQL Server has encountered 1 occurrence(s) of cachestore flush

    Got nothing to do with those messages.

    Restore time is mostly about IO.

    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

    December 1, 2011 at 9:20 am

    #1415347

  • RE: SQL Server has encountered 1 occurrence(s) of cachestore flush

    Restoring a database always causes a flush of the plan cache. Hence, any time you restore a DB you'll see those messages.

    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

    December 1, 2011 at 7:55 am

    #1415281

  • RE: A Refreshing Break

    I've just come back from almost a week in the middle of nowhere (also known as the eastern Free State). No cell signal (except from a certain point at 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

    December 1, 2011 at 7:33 am

    #1415258

  • RE: SQL Server has encountered 1 occurrence(s) of cachestore flush

    That's not an error. It's just telling you that the plan cache has been cleared. A restore of a database always clears the plan cache.

    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

    December 1, 2011 at 7:26 am

    #1415250

  • RE: Get Changes to Objects form DMV's as opposed to Database Triggers

    There's no DMV that stores that info. It's in the default trace, but only until the trace rolls over (5 files of 20MB each)

    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

    December 1, 2011 at 7:25 am

    #1415248

  • RE: How to Encrypt Database Objects in SQL Server 2008R2

    anthony.green (12/1/2011)

    i think the question is, how do you get the padlock on objects like some 3rd parties do, one example is LiteSpeed, where the properties of the object show...

    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

    December 1, 2011 at 7:24 am

    #1415247

  • RE: Does specifying COPY_ONLY make a difference?

    Suresh B. (12/1/2011)

    COPY_ONLY does not break the log chain.

    Full backups do not EVER break the log chain, regardless of whether they're taken with copy_only or not..

    So if you have...

    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

    December 1, 2011 at 7:23 am

    #1415245

  • RE: How to Encrypt Database Objects in SQL Server 2008R2

    azhar.iqbal499 (12/1/2011)

    I have created TDE from sa user and I logged in with another user with same rights. But all DB objects were looking unencrypted.

    Yes, because TDE is encryption...

    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

    December 1, 2011 at 7:21 am

    #1415243

  • RE: Restoring a COPY_ONLY backup

    adb2303 (11/25/2011)

    I take the copy_only backup because I don't want my 15 min trans log backups to be based on my adh-hoc support full backup...

    They won't be, whether you...

    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 25, 2011 at 3:43 am

    #1412928

  • RE: Restoring a COPY_ONLY backup

    It's a known bug with copy-only backups. The GUI doesn't work, so you have to restore with T-SQL. It's a management studio bug.

    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 25, 2011 at 3:40 am

    #1412926

Viewing 15 posts - 21,961 through 21,975 (of 49,552 total)