Post reply

difference in backup

  • May 25, 2009 at 10:51 am

    #134375

    Hi,

    Can anyone please tell me the difference in backup in sql server 2000 and 2005

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • May 25, 2009 at 11:04 am

    #999713

    There aren't that many. Fundamentals are the same.

    Backup and restore gained the CHECKSUM and CONTINUE_AFTER_ERROR options

    On the restore side there's fast recovery (enterprise only), online restores (Enterprise only)

    Can't think of any others offhand. Have a look through Books Online, specifically the "What's new in SQL 2005" All the details of all the changes are there.

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply