SQL server backup and truncate log file

alwinkotiya

Hi all,

If I set recovery model SIMPLE then truncation of log files will be
automated , but I will lose
database changes made since the last backup was taken.
Is there any way to automate truncation of log file and
backup of database upto last change has been done????

Plz Help.

Jun 13 '06 #1

Subscribe Post Reply

11791

Robert Klemme

al*********@gmail.com wrote:

Hi all,

If I set recovery model SIMPLE then truncation of log files will be
automated , but I will lose
database changes made since the last backup was taken.
Is there any way to automate truncation of log file and
backup of database upto last change has been done????

Maintenance plan.

robert

Jun 13 '06 #2

alwinkotiya

I did not get you. Please specify.

Robert Klemme wrote:

al*********@gmail.com wrote:
Hi all,

If I set recovery model SIMPLE then truncation of log files will be
automated , but I will lose
database changes made since the last backup was taken.
Is there any way to automate truncation of log file and
backup of database upto last change has been done????

Maintenance plan.

robert

Jun 13 '06 #3

Erland Sommarskog

(al*********@gmail.com) writes:

If I set recovery model SIMPLE then truncation of log files will be
automated , but I will lose
database changes made since the last backup was taken.
Is there any way to automate truncation of log file and
backup of database upto last change has been done????

Wait here. You don't want to truncate the log regularly. Then you can
just as well run with simple recovery model. What you want to do is
to *back up* the transaction log regularly.

The best way to do this is of course to do it from SQL Server Agent. You
can use the interactive dialog in for backup in Enterprise Manager/Mgmt
Studio and schedule the job from these dialogs.

Provided, that is, you are not running SQL 2005 Express which does not
include Agent.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jun 13 '06 #4

by: rjp | last post by:

Hi, I am using a SQLServer 7 SP4 version. I have scheduled one job with the SQLServer agent which backup the log of the databases every day. The command is : "backup log base to with noinit"...

Microsoft SQL Server

Transaction log size after backup.

by: D. Buck | last post by:

I have a MS SQL 2000 dB that is 3GB, the transaction log is about 2GB. I do a full dB backup every night. My question is, shouldn't the transaction log shrink down to next to nothing after a full...

Microsoft SQL Server

Transaction Logging Backup Set

by: Thiko | last post by:

Hi I take one nightly full database backup at 02:00 and backup the transaction log to one backup set every 15mins. The commands to do this are as follows and are set up to run as database...

Microsoft SQL Server

Does the transaction log on a publisher SQL server get truncated when the database is backed up, but the distributor is down?

by: mokles | last post by:

Hello All, The setting is SQL server 7, on Windows NT. If the distributor can not access the log on the publisher database ( but subscribers are not deleted yet), will the full backup of the...

Microsoft SQL Server

dbcc shrinkfile - SQL Server 2000 - invalidate log?

by: deebeeay | last post by:

Hi, I need to shrink a database file and was wondering whether it is required to run a full backup after the shrink operation. In SQL Server 7.0 shrinkfile was a non-logged operation so would...

Microsoft SQL Server

Does a Full Backup include transaction logs

by: Brian D | last post by:

In MS SQL 2005 when you do a Full Backup does it also backup and truncate the transaction logs or do I need to back the transaction logs up separately? Thanks. Brian

Microsoft SQL Server

SQL 6.5 server connection problem

by: sherifbk | last post by:

Problem description ============== - I have 4 clients and 1 server (SQL server) - 3 clients are Monitoring console 1 client is operation console - Monitoring console collects some data from...

Microsoft SQL Server

How do I make a backup device file smaller ?

by: David Greenberg | last post by:

Hi I have a backup device file ... ".bck" whick has grown pretty large. Is there any way I can reduce its size ? Thanks David Greenberg

Microsoft SQL Server

does this backup sequence commit all data to the database

by: Roger | last post by:

backup log testdb with truncate_only DBCC SHRINKFILE (testdb_log, 100) WITH NO_INFOMSGS backup database testdb to disk = '\\DC01\Backups\DB01\testdb.bak' with init and does the shrinkfile...

Microsoft SQL Server

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

VBA Class Basics

by: NeoPa | last post by:

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...

Microsoft Access / VBA

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA

SQL server backup and truncate log file

Similar topics