SQL database backup
Please support our MS SQL advertiser: Programming Forums
 |
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
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
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
you must also apply all transaction logs before recovering the database, otherwise you must start over
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
|
Similar Threads
Other Threads in the MS SQL Forum
- Back Up of SQL database in C# (C#)
- SQL Server question (MS SQL)
- SQL For MS Access? (MS Access and FileMaker Pro)
- Sql/dba (Software Development Job Offers)
- SQL Server 7.0 BackUP and Restore Code (Visual Basic 4 / 5 / 6)
- VB backup and restore program (Visual Basic 4 / 5 / 6)
- Database Backup Question (Newb :0) (MS SQL)
- what to do with this .SQL script? (MySQL)
- Help with shell script to auto gzip a .sql dump after backup (Shell Scripting)
Other Threads in the MS SQL Forum
- Previous Thread: Log shipping SQL 2000
- Next Thread: Transfer of data
•
•
•
•
Views: 705 | Replies: 2 | Currently Viewing: 1 (0 members and 1 guests)
Linear Mode
