Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does anyone know of a nice tool that can be scheduled to backup databases & logs and truncate logs?

Is use SQL Server 2008 Web Edition

share|improve this question

closed as off-topic by HBruijn, HopelessN00b Jan 28 '15 at 8:08

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

I agree with a couple of the answers below - unless you've got unstated requirements, I would just use the native SQL maintenance plans to do this. – mfinni Jan 19 '11 at 14:36
don't truncate your logs either; might as well go simple recovery mode if you're going to do that. – SqlACID Jan 19 '11 at 17:28

Is there a reason that you want a special tool for this instead of setting up scheduled maintenance jobs in SQL Server Agent? What are your requirements?

I recommend the scripts from Ola Hallengren that is free to use as a way to set up basic backup solution. It sets up the SQL Agent jobs, the only thing you have to do is enable and schedule when and what of the backup jobs you want to run. It writes the backups to your default backup directory, so be sure to change the parameter in the jobs if this is not your intended destination.

share|improve this answer

Symantec BackupExec with the SQL Server agent does this.

share|improve this answer

Really simple & free approach is Windows Scheduler running your own scripts using the sqlcmd tool that comes with SQL Server.

Not sure why so many people avoid rolling their own backup scripts and scheduling them when they're using editions that don't have a SQL Agent installed.

Good examples of sqlcmd here.

share|improve this answer
Web Edition should have SQL Agent. – Michael Eklöf Jan 19 '11 at 14:19
Hadn't realized WedEdition has SQL Agent - definitely a no-brainer to use that then unless there's some requirements that aren't mentioned in the question. – Chris W Jan 19 '11 at 14:39

Use a tool like Symantec BackupExec to compress the backups to a central location, another option is Red Gate's SQL Backup tool that does compression. The other option is as others have said is to do a backup directly in SQL, but unless you have enterprise, it won't compress the data.

share|improve this answer

We use a combination of SQL Server Agent + Windows Task Scheduler to backup, zip databases and copying them to an external disk.

share|improve this answer

There is obviously the native SQL Server tool, Redgate has a good backup and there are others out there. I guess it really depends on the problem you are trying to solve.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.