 |  |  |  |  |  |  |  |
SQL database backup
Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
•
•
Join Date: Aug 2008
Posts: 1,162
Reputation: 
Solved Threads: 138
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
- VB backup and restore program (Visual Basic 4 / 5 / 6)
- SQL Server question (MS SQL)
- Back Up of SQL database in C# (C#)
- 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)
- 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: 792 | Replies: 2
| Thread Tools | Search this Thread |
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MS SQL
"last autogrowth business connectingtodatabaseinuse count cursor data database dateadd datepart day" dbsize deadlock delete_trigger exploit getdate hack highperformancecomputing hpc hpcserver2008 ibm iis limit live loop maximum microsoft ms mssql multiple multithreading news number password permission position query reporting result security server services sets single source sql sql-injection sqlserver sqlserver2005 subtype supercomputing supertype tables uniqueid update view weekday
