Solved

How to backup SQL DB and truncate logs

Posted on 2013-01-18
4
379 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 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 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
OSQL to execute sql command 26 24
Solar Winds can't see SQL Server Express 17 32
Migration from SQL server to oracle (XML input) 4 23
Parse this column 6 25
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
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…

840 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