Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rahul Kr. Ghosh Automated Trigger To Require a WHERE Clause RE: Automated Trigger To Require a WHERE Clause

  • January 25, 2011 at 4:43 am

    #1277723

    jts_2003 (1/25/2011)

    What would be great is an easy way of backing up (and restoring) just a table... maybe in Denali?

    No, and I doubt it will ever be a native feature. It allows the database to be in a transactionally inconsistent state. Lots of the 3rd party backup tools can do that, and others allow the backups to be 'mounted' as if they were actual databases (RedGate's Hyperbac for eg)

    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