Backup

  • 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...

  • 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)

  • 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

  • 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

  • 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 4 (of 4 total)

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