Home / server / Questions / 234846
Accepted
Letseatlunch
Asked: 2011-02-13 14:41:43 +0800 CST

Good tools for backing up SQL Server?

  • 772

Im "new" to SQL Server and i want to start doing backups of all my data. Whats a good starting place? are there any good tools out there for this? Also i'd like it if i could have backups that could be potential loading into another instance of SQL Server on a separate Server incase our current one "dies"

windows-server-2008 sql-server backup

2 Answers

  1. Best Answer

    In the first instance use what SQL Server provides - http://technet.microsoft.com/en-us/library/ms187658.aspx

    Maintenance plans are the quickest and easiest way to backup your databases, and you can use the .bak files to populate another server.

    If you're already running another backup system (Like Backup Exec) you could also investigate what addons they have for SQL Server.

    • 6

  2. I assume you mean MS SQL?

    You could start with a SQL Agent job to dump the database to a file which can then be backed up. This can be a regular job.

    If you're on SQL Express you can accomplish the same thing with a Windows scheduled task I think.

    • 0