943,569 Members | Top Members by Rank

Web Development > Databases > MS SQL > SQL database backup
Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 874
  • MS SQL RSS
Permalink
Nov 20th, 2008
0

SQL database backup

Expand Post »
Hello,
I have question about backup and restore procedure for MS SQL 2000.

If I make a full backup on Saturday and Transactional backup on Sun - Friday. When restoring I know sequence matters but what if I make a mistake and select transaction log out of sequece to restore. Do I have to restart the restore process?

Thanks,
dc9
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
imohammed is offline Offline
4 posts
since Nov 2008
Permalink
Nov 20th, 2008
0

Re: SQL database backup

you shouldn't be able to restore a transaction log that isn't in the proper sequence, you will only be able to restore up to the point the last sequential transaction log

you must also apply all transaction logs before recovering the database, otherwise you must start over
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Reputation Points: 10
Solved Threads: 9
Junior Poster
sierrainfo is offline Offline
144 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: Log shipping SQL 2000
Next Thread in MS SQL Forum Timeline: Transfer of data





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC