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
Jump to Postyou 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
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.