Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Reload this Page Backup Log Files out of order
|
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 March 15th, 2007, 11:10 AM
Authorized User
  
Join Date: Jun 2003
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Default Backup Log Files out of order
Hi all,

I am testing my log shipping and it happened that I deleted the first log file. So now my trans. logs is out of order. How can I fix this problem quick please?

Thanks.
 
Old March 15th, 2007, 03:51 PM
Friend of Wrox
  
Join Date: Aug 2004
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default
never delete!!!!

Probably need to backup from source and restore to target.
 
Old March 16th, 2007, 01:41 AM
Friend of Wrox
  
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default
You lost the sequence by deleting it, start from scratch in order as rob said.

cheers.

_________________________
- Vijay G
Strive for Perfection





Similar Threads
Thread Thread Starter Forum Replies Last Post
Create backup folder & also backup files miracles Excel VBA 0 April 16th, 2007 02:28 AM
backup transaction log file rohit_sant SQL Server 2000 3 September 26th, 2006 11:09 AM
HUGE Log Files - Help?!? MAtkins SQL Server 2000 4 August 30th, 2005 03:13 PM
T-Log Backup koushikroy2001 SQL Server 2000 0 August 11th, 2005 03:58 AM
Backup Tx log vincentc SQL Server 2000 0 September 15th, 2003 08:42 PM




Contact Us - Wrox - Privacy Statement - Top

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