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.
Author |
Topic |
ddamico
Yak Posting Veteran
76 Posts |
Posted - 2009-01-13 : 11:41:25
|
I already know the answer to this question but I am going to ask it anyway.Someone at our company deleted a subsite of our sharepoint site and we are trying to restore the documents. The issue is we don't have a full backup of the database that can be used only transaction logs. Somehow the full backup is missing from our system backups. Is there a way that you make a full backup of the database and apply transaction in reverse order to get it back to a point.Probably not but it worth the question. Thanks |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-01-13 : 16:08:35
|
you might want to check some 3rd party log readers like Lumigent or Redgate___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-14 : 02:07:57
|
How and why are you taking log backups in the first place without a full backup? The whole point log backups is so that you can restore a full backup and then all of the log backups, one by one, in sequence, to get to the point of failure.How do you expect to be able to recover that should a critical drive fail?--Gail ShawSQL Server MVP |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-01-14 : 09:02:28
|
You can't take log backups without having done a full backup at some point in time. But you would need to find that backup file and ALL the log dumps since then.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
|
|