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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Backup Question
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

76 Posts

Posted - 01/13/2009 :  11:41:25  Show Profile  Reply with Quote
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

Almighty SQL Goddess

38200 Posts

Posted - 01/13/2009 :  12:46:05  Show Profile  Visit tkizer's Homepage  Reply with Quote
That is not possible.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server

Subscribe to my blog
Go to Top of Page

Cybernetic Yak Master

11752 Posts

Posted - 01/13/2009 :  16:08:35  Show Profile  Visit spirit1's Homepage  Reply with Quote
you might want to check some 3rd party log readers like Lumigent or Redgate

Causing trouble since 1980
Speed up SSMS development: <- version 1.1 out!
Go to Top of Page

Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/14/2009 :  02:07:57  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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 Shaw
SQL Server MVP

Edited by - GilaMonster on 01/14/2009 02:22:04
Go to Top of Page

Flowing Fount of Yak Knowledge

2365 Posts

Posted - 01/14/2009 :  09:02:28  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000