Member Avatar for imohammed

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

  • 3 Contributors
  • 2 Replies
  • 85 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by sierrainfo
Member Avatar for dickersonka

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.