How to backup SQL DB and truncate logs

Posted on 2013-01-18
Medium Priority
Last Modified: 2013-02-02

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
Question by:caw01
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38794079
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38795212
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.
LVL 10

Expert Comment

by:Monica P
ID: 38795775

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

LVL 43

Accepted Solution

Eugene Z earned 2000 total points
ID: 38799885
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

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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.

Join & Write a Comment

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question