How to backup SQL DB and truncate logs

Hello,

We have an application that uses a SQL 2008 express DB.  Its a small DB and there is no need to pay for a SQL Agent to backup the DB.

I'd like to script and schedule a daily backup that will also truncate the logs so that backup will get picked up by the file level backup.

Can someone help me with the script and how to schedule it?

Thank you
caw01Asked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
check this full free MS solution with the desired script and step -by-step instructions:

How to schedule and automate backups of SQL Server databases in SQL Server Express
http://support.microsoft.com/kb/2019698
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
Anthony PerkinsCommented:
I'd like to script and schedule a daily backup that will also truncate the logs so that backup will get picked up by the file level backup.
If you are not prepared to make frequent Transaction Log backups in addition to Full database backups, consider setting the Recovery Model to Simple instead of Full.  Just keep in mind that you will lose point-in-time restores if you use Simple Recovery Model.
0
 
Monica PSoftware DeveloperCommented:
Hi

You can use this tool to take BACKUP and can Schedule this Application in schedular

http://sqlbackupandftp.com/?ref=242
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.