Solved

How to backup SQL DB and truncate logs

Posted on 2013-01-18
4
374 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
4 Comments
 
LVL 142

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 42

Accepted Solution

by:
EugeneZ 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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

803 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