Solved

How to backup SQL DB and truncate logs

Posted on 2013-01-18
4
383 Views
Last Modified: 2013-02-02
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
0
Comment
Question by:caw01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38794079
0
 
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.
0
 
LVL 10

Expert Comment

by:Monica P
ID: 38795775
Hi

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

http://sqlbackupandftp.com/?ref=242
0
 
LVL 43

Accepted Solution

by:
Eugene Z earned 500 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
http://support.microsoft.com/kb/2019698
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CAST issue with SQL 2000 15 44
SQL Job Failed 6 30
Migrate SQL 2005 DB to SQL 2016 4 28
Microsoft SQL Query sum values over time periods 3 21
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Viewers will learn how the fundamental information of how to create a table.

732 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