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 Reply

11824

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

Similar topics

2901

Log file automaticaly shrink during backup log without particular option

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

9583

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

7554

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

1706

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

4851

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

18214

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

5098

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

3495

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

3475

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

7041

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

6908

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7043

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7081

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6737

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

6921

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5336

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4481

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

563

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP