Simplest backup

  • Mine was an alternative to sqlcmd.

     

    Kind regards,
    Gift Peddie

  • I wouldn't rely on just one mode of backups. If your database structure has become static, then I would start BCPing and zipping your tables nightly. It's a much faster restore if a table gets wiped out. Also I would generate scripts for all of your databases. I would also do a backup of the root drive nightly also.

    I would say that I use my BCP dumps more often then I use my nightly SQL Server backups.

    Backing up to multiple formats and moving them out of the machine is the only way to make sure that you are safe.


    Live to Throw
    Throw to Live
    Will Summers

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

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