Forum Replies Created

Viewing 15 posts - 15,451 through 15,465 (of 49,552 total)

  • RE: Full, Log & Differential Backups

    raotor (11/28/2012)

    What about the log backups though?

    Same. One per file stamped with the datetime in the name

    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 28, 2012 at 11:47 pm

    #1563563

  • RE: LUN

    weberharter (11/28/2012)

    ... but if the terms are used here, why not explain it? 😉

    Because we assume that people know the basic terminology or, if they don't, will go and look...

    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 28, 2012 at 2:26 pm

    #1563457

  • RE: Backup policy for 2 TB database (Interview perspective)

    catchmekiran (11/28/2012)

    Could you please say in general

    There's no 'general' solution to backing up a 2 TB database.

    General: Backup often enough that you will be able to restore to meet your...

    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 28, 2012 at 1:46 pm

    #1563433

  • RE: LUN

    Nothing.

    A LUN is a SAN concept, not a database concept.

    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 28, 2012 at 1:43 pm

    #1563432

  • RE: Difference between varchar(max) and varchar(8000)

    Please note: 3 year old thread (and what I was in this thread was incorrectly accused of being wrong. I've been wrong elsewhere, but not here)

    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 28, 2012 at 1:24 pm

    #1563421

  • RE: Backup policy for 2 TB database (Interview perspective)

    catchmekiran (11/28/2012)

    Backup policy for a 2 TB database.....

    what would you recommend exactly and why for each day of the week. what you would do daily, weekly and monthly.

    Not enough information....

    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 28, 2012 at 1:01 pm

    #1563414

  • RE: Full, Log & Differential Backups

    raotor (11/28/2012)

    My full backups are done to the same file (i use NOINIT option on BACKUP), so the same physical backup file contains both full backups as far as I...

    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 28, 2012 at 12:55 pm

    #1563413

  • RE: Are the posted questions getting worse?

    One thing that's important to note is that the query processor is a pipeline. It does not execute each operator one by one on the entire resultset, so, in 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 28, 2012 at 12:52 pm

    #1563409

  • RE: Full, Log & Differential Backups

    The problem is that you're using the GUI. Don't.

    Script your restores (there are scripts that will create the restore statements for you from MSDB). There's no broken log chain here,...

    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 28, 2012 at 12:41 pm

    #1563398

  • RE: Full, Log & Differential Backups

    raotor (11/28/2012)

    Today I performed a second full database backup after thinking I wouldn't destroy the chain and now I cannot restore the database to a point in time before 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 28, 2012 at 12:06 pm

    #1563375

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/28/2012)

    Data read by the query processor goes somewhere. When in SSMS, it's outputting to the screen or the file, so it makes sense to me that these pages...

    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 28, 2012 at 12:05 pm

    #1563372

  • RE: Restore DB backup from Enterprise Edition to Standard Edition

    Please note: year old thread.

    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 28, 2012 at 11:03 am

    #1563343

  • RE: Are the posted questions getting worse?

    Anyone with more patience than me want to try and handle this?

    http://www.sqlservercentral.com/Forums/Topic1389777-1550-1.aspx

    Previous threads on the subject:

    http://www.sqlservercentral.com/Forums/Topic1382850-1550-1.aspx

    http://www.sqlservercentral.com/Forums/Topic1368391-1550-1.aspx

    http://www.sqlservercentral.com/Forums/Topic1364097-1550-1.aspx

    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 28, 2012 at 10:49 am

    #1563335

  • RE: Cost threshold for parallelism

    SQLSACT (11/28/2012)

    Just my limited experience talking here but I find it weird that MS would change something that we could relate to something that has no meaning.

    They haven't.

    The cost has...

    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 28, 2012 at 10:22 am

    #1563313

  • RE: Buffer Pool Dirty/Clean Pages

    SQLSACT (11/28/2012)

    Thank You Gail

    Please bear with me

    The 8kb page in memory is written to disk, to the appropriate 8kb chunk of the data file.

    On one of my posts regarding this,...

    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 28, 2012 at 10:20 am

    #1563310

Viewing 15 posts - 15,451 through 15,465 (of 49,552 total)