Backup

  • Vladimirm_2

    SSC Enthusiast

    Points: 117

    Hi All,

    Regarding Microsoft:

    You must use SQL Server 2000 or third-party database backup programs to back up online database files. Windows 2000 and Windows NT 4.0 backups cannot back up files that are in use and for this reason cannot back up online SQL Server 2000 database files.

    ....

    I tried to find this kind of software, but so far I couldn't...Does anyone know any one ?

    Thanks.

    Press any key to continue or any other key to exit...


    Press any key to continue or any other key to exit...

  • Antares686

    SSC Guru

    Points: 125444

    BackupExec is one such app but there are quirks about some oyu have to be carefull of. Personally I use SQLs BACKUP DATABASE process which works just fine to do backups to file or tape.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Prakash Heda

    SSCertifiable

    Points: 5538

    veritas backup is what I am using for 500GB database

    Prakash

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 717276

    SQL Server can make it's own backups to disk, which any tape system can back up. This is the recommended method.

    I'd avoid using 3rd party backup.

    Steve Jones

    steve@dkranch.net

  • Vladimirm_2

    SSC Enthusiast

    Points: 117

    Ok, Thank you all !!

    Press any key to continue or any other key to exit...


    Press any key to continue or any other key to exit...

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

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