July 7, 2011 at 4:58 pm
Dear Guru's
Need your help. Is it possible point in time recovery with a full backup file without any log backup? I dont think so!!! do you???
For more understanding, my scenario is
1. New SQL2005 user database created on 1/6/11
2. User were testing every day. all DML took place on this db from 1st june up to today 7/7/11.
3. We have a full database backup as at 30th june 2011. (1 month data)
4. No transaction log backup at all since day one.
5. Now user need the data to be backed dated as at 25/6/11. How do I recover data backward from my full backup as at 30/6/11?
my question are:
6. Is point in time recovery can be done without transaction log backup?
7. Can we do backward point in time recovery?
Please help.
thank you
July 7, 2011 at 5:08 pm
er, sorry, no.
---------------------------------------------------------------------
July 7, 2011 at 5:20 pm
If the database is in Full Recovery Model, you can do a single log backup and point in time restore from that. However, if you are using Simple, then the transaction log does not have the entries from the last month anymore, so no point-in-time recovery.
http://msdn.microsoft.com/en-us/library/ms189275.aspx
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
July 7, 2011 at 5:30 pm
Without a log backup, you will not be able to do a point in time recovery.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2011 at 5:52 pm
siva_krishnan (7/7/2011)
3. We have a full database backup as at 30th june 2011. (1 month data)4. No transaction log backup at all since day one.
5. Now user need the data to be backed dated as at 25/6/11. How do I recover data backward from my full backup as at 30/6/11?
First full backup: 6/30/11. This is the start point for ANY recovery you could do. This falls under the SOL category of issues. Sorry dude.
You might see if network does backups to tape for you and do a recovery on the mdf file that way, but they can be very unpretty.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 8, 2011 at 12:03 am
Thanks for the reply.
Thank you all for sharing your exp/knowledge.
🙂
July 8, 2011 at 9:42 am
On behalf of all - you are welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply