Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
2  
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
1  
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

6 Answers 6

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

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

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

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

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
1  
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

Symantec BackupExec with the SQL Server agent does this.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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