SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

ddamico
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

tkizer
Almighty SQL Goddess

USA
35953 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
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11749 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
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!
Go to Top of Page

GilaMonster
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

blindman
Flowing Fount of Yak Knowledge

USA
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  
 New 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.06 seconds. Powered By: Snitz Forums 2000