November 11, 2011 at 8:14 am
I have a database on SQL server 2008 . It is deployed on HP PROLIANT 380 G7.
Operating system is windows server 2008. The server has 8 hard disks with RAID 5 configuration
Logical Drive(1) C: four disks and further divided in to C and G
Logical Drive(2) E : Four disks and further divided into two logical drives E and F
the DBMS is installed in C and the temp is in F.
We have a database with real data in E and Log in G.
Today we found that Drive E and F are not working ( Disappeared). We contacted HP for support and we understand that some body(for the time being not known ) replaced and reseated physical drive in Logical drive (1). So, they informed me that the data is lost.
Question: For different reason we didn't take backup for the last few days(5 days) which could be large amount of data. 5 days a go we have full back up (offline). And today we have got the log file in Drive G. / the DBMS doesn't start currently)
How can we restore the the previous 5 days data from log file . Thank U for your help......
For your information: we have only log file only for the last five days( The difference)
November 11, 2011 at 8:18 am
You probably can't.
What recovery model was the database in?
What exactly do you mean by 'a full backup (offline)'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 11, 2011 at 8:19 am
What do you mean by offline backup??
AFAIK, if somehow you're able to bring back the db online you'll be able to take a log backup to do the restore up to the time of the issue.
Obviously it would be useless at that point.
If you don't have the log backups available since the full backup, you can't do anything other than restore the full DB as of 5 days ago.
November 11, 2011 at 8:21 am
Ninja's_RGR'us (11/11/2011)
AFAIK, if somehow you're able to bring back the db online you'll be able to take a log backup to do the restore up to the time of the issue.
You don't need to bring a DB online to do a log backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 11, 2011 at 8:25 am
GilaMonster (11/11/2011)
Ninja's_RGR'us (11/11/2011)
AFAIK, if somehow you're able to bring back the db online you'll be able to take a log backup to do the restore up to the time of the issue.You don't need to bring a DB online to do a log backup.
Ok, I was assuming that you needed to see the db in the list and that if the data files were gone they wouldn't be there... hence catch 22.
Note to self, I need to start testing all the stuff I read!
Shuffles schedule around to remove that useless sleep!
November 11, 2011 at 8:37 am
What exactly do you mean by 'a full backup (offline)'
I guess its OS backup of database files (MDFs & LDFs) either by DETACH or OFFLINE (preferred). It's common in Oracle for small DBs where IT support plays DBA role.
November 11, 2011 at 8:39 am
Dev (11/11/2011)
What exactly do you mean by 'a full backup (offline)'
I guess its OS backup of database files (MDFs & LDFs) either by DETACH or OFFLINE (preferred). It's common in Oracle for small DBs where IT support plays DBA role.
I prefer not to guess when it comes to disaster recovery. I want to hear direct from the OP what exactly he has and what his exact situation is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 11, 2011 at 8:39 am
Dev (11/11/2011)
What exactly do you mean by 'a full backup (offline)'
I guess its OS backup of database files (MDFs & LDFs) either by DETACH or OFFLINE (preferred). It's common in Oracle for small DBs where IT support plays DBA role.
My guess too, and certainly Gail's fear, as she won't be able to do anything unless they recover the mdf file.
November 11, 2011 at 9:08 am
Thank U for your reply:
When I say Full backup ( offline).... we have the full backup taken 5 days a go and in external storage and now we are able to restore in another server up to that date. The problem is we didn't take the backup after that . Currently We have only the log file ( For the last five days ). any possibility to recover the last 5 days data from the log file .
November 11, 2011 at 9:09 am
It is in Full recovery Model
November 11, 2011 at 9:10 am
assefam (11/11/2011)
Thank U for your reply:When I say Full backup ( offline).... we have the full backup taken 5 days a go and in external storage and now we are able to restore in another server up to that date. The problem is we didn't take the backup after that . Currently We have only the log file ( For the last five days ). any possibility to recover the last 5 days data from the log file .
HOW did you take the backup. That changes everything!
November 11, 2011 at 9:15 am
assefam (11/11/2011)
Thank U for your reply:When I say Full backup ( offline).... we have the full backup taken 5 days a go and in external storage and now we are able to restore in another server up to that date.
Doesn't help me. What EXACTLY do you mean by an offline backup? Was it a normal SQL Server backup that you then took to an offline server? Or did you take the database offline and copy the files?
Do you have log backups? If not, how are you managing your transaction log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 11, 2011 at 9:31 am
Please Help: Is it possible to take buckup from Log file with out bring DB online. For your information, the real data is not available
November 11, 2011 at 9:33 am
assefam (11/11/2011)
Please Help: Is it possible to take buckup from Log file with out bring DB online. For your information, the real data is not available
Help us to help you.
What EXACTLY do you mean by an offline backup? Was it a normal SQL Server backup that you then took to an offline server? Or did you take the database offline and copy the files?
Do you have log backups? If not, how are you managing your transaction log?
November 11, 2011 at 9:37 am
assefam (11/11/2011)
Please Help: Is it possible to take buckup from Log file with out bring DB online. For your information, the real data is not available
I need you to answer my questions. I'm not asking for my own amusement. I'm asking because the answers to these affect how (and if) we proceed.
What EXACTLY do you mean by an offline backup? Was it a normal SQL Server backup that you then took to an offline server? Or did you take the database offline and copy the files?
Do you have log backups? If not, how are you managing your transaction log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 1 through 15 (of 29 total)
You must be logged in to reply to this topic. Login to reply