Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 16th, 2004, 04:50 AM
Friend of Wrox
 
Join Date: Oct 2003
Posts: 463
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to madhukp
Default use of transaction log

Hi friends,

May I know what is the purpose and use of Transaction logs ? I have a particular situation.

I have yesterday's backup of a database. One batch updation operation which was done today was wrong and as a result a large number of records from one table is lost. Can I use yesterday's backup together with transaction log to restore all data prior to the wrong operation which lead to data loss ?

Thanks

Madhu
 
Old July 16th, 2004, 06:20 PM
Registered User
 
Join Date: Apr 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to bizzeau Send a message via MSN to bizzeau
Default

You can do a point in time restore, but only if you have your tran logs on differential backups. If you do not, and you choose to restore the previous days data, you will lose all data from the backup completion point forward.

Beau Frusetta
SQL Server DBA/Developer
Web/Desktop Application Developer
Unicorn Financial Services/Contractor For Hire
(480) 980-1611
[email protected]





Similar Threads
Thread Thread Starter Forum Replies Last Post
Transaction log carumuga SQL Server 2005 0 August 7th, 2008 05:38 AM
Truncating Transaction Log ninel SQL Server 2000 1 November 18th, 2006 01:26 PM
transaction log full Jane SQL Server 2000 1 January 28th, 2004 09:59 AM
log and transaction issue ak SQL Server 2000 0 September 29th, 2003 06:32 AM
Transaction Log ColdFusionRO SQL Server 2000 3 July 16th, 2003 01:47 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.