Forum Replies Created

Viewing 15 posts - 16 through 30 (of 74 total)

  • RE: Can't restore or attach database (it's not corrupt)

    mxy (4/29/2015)


    is it a native backup or using a third party tool.

    native

    what is the extension of the backup file.

    .bak

    can you do restore headeronly and filelistonly on the server...

  • RE: Can't restore or attach database (it's not corrupt)

    Steve Jones - SSC Editor (4/29/2015)


    That is strange. I can't help but think that you have a version issue somewhere, or perhaps a weird network issue. You also say a...

  • RE: Can't restore or attach database (it's not corrupt)

    Backups are being done to a local drive and are copied over the network to the other machine.

  • RE: Can't restore or attach database (it's not corrupt)

    Thanks for the suggestions. Version was one of the first things I checked. Both instances of SQL are running the exact same version (9 SP4, build #9.0.5069). I will try...

  • RE: Scrubbing Personally Identifiable Information

    Scrubbing the data while it is still secure is very important and I addressed that in the overview, but I failed to say why. That was an oversight on...

  • RE: Scrubbing Personally Identifiable Information

    If there is a number range that will never be used for SSNs, it may make a lot of sense to use it for scrubbed data. I wasn't suggesting that...

  • RE: Always Abstract

    Where I work, we have kind of a hybrid approach. We recently created views for all our tables, refactored the code, and then removed all access to those tables from...

  • RE: SQL Server Best Practices

    That's not completely possible in our system right now. We have however, created views for all select access, and we do require that all inserts, updates, or deletes occur through...

  • RE: SQL Server Best Practices

    Jayanth_Kurup (9/22/2012)


    The points above are pretty comprehensive and from real world experience i know that most developers will pick a few favorite points from here and implement them. One additional...

  • RE: SQL Server Best Practices

    L' Eomot Inversé (9/22/2012)


    I won't repeat what others have already said; I agree in particular with what Jeff wrote.

    Table Design

    3.Do not blindly normalize everything

    Risks being read as a license to...

  • RE: SQL Server Best Practices

    GilaMonster (9/22/2012)


    If your intent is to avoid unnecessary table scans because of poorly written queries, then someone needs to review query and execution plan to ensure that it is optimal...

  • Viewing 15 posts - 16 through 30 (of 74 total)