DaniWeb IT Discussion Community - SQL database backup

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- MS SQL (http://www.daniweb.com/forums/forum127.html)

- - SQL database backup (http://www.daniweb.com/forums/thread158556.html)

imohammed

Nov 20th, 2008 9:53 am

SQL database backup

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

dickersonka

Nov 20th, 2008 11:06 am

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

sierrainfo

Nov 21st, 2008 1:33 am

Re: SQL database backup

http://www.microsoft.com/technet/pro...ackuprest.mspx

http://www.disksave.com/help/obs-use...-oem.1.11.html

All times are GMT -4. The time now is 1:56 am.