Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Restoring File Backups clarification needed

Author  Topic 

ann06
Posting Yak Master

171 Posts

Posted - 2008-07-01 : 10:22:03
i read in msdn article for restoring a damaged file or files from file backups:
first step is

1. Back up the active transaction log. If you cannot do this because the log has been damaged, you must restore the entire database.

why i have to restore the entire database why i only restore the damaged files then restore all the transaction logs backups except the last one(till the one before the active trns. log)?

Thanks very much

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-07-02 : 01:29:32
If the the files are damaged, then how would you be able to restore the transaction logs?


Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-04 : 21:38:55
I believe it's about rebuilding damaged log file.
Go to Top of Page
   

- Advertisement -