Post reply

Fastest way to create a full Database Backup

  • August 17, 2007 at 12:55 am

    #118129

    Hi,

    what is the fastest way to create a full Database Backup with SQL Server 2000?

    - normal full Database Backup

    - Snapshot Replication

    - Snapshot Backup with some other third party tools

    - anything else..

    Thanks in advance

    Jürgen

  • August 17, 2007 at 3:10 am

    #727574

    Jurgen,

    A Snapshot backup would be the fastest way to backup your data however this can often be very expensive as it require three way mirror drives.

    Replication, or log shipping, would normally be seen as a good way of ensuring high availability but you also need to perform some sort of backup (and would need a second live server).

    If you are looking for somthing which is not too expensive but also is quicker than Native backup then have a look at third party backup tools - Red Gate (who I work for) do one called SQL Backup and this might meet your requirements.

    Hope this helps,

    James

     

     

    --
    James Moore
    Red Gate Software Ltd

  • August 17, 2007 at 5:27 am

    #727592

    Hello James,

    thanks for your summery - i have in the meantime ordered a offer of SQL Backup form the Austrian Partner :-))

    Have a nice weekend

    Jürgen

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

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