Restore  
Author Message
Gwenael





PostPosted: Mon Sep 29 13:21:42 CDT 2003 Top

SQL Server >> Restore

Hello:

We had a user/administrator here make a mistake.

What I have is the following:

1. A backup from August 18th
2. An mdf file and an ldf file from Sept 23rd

Facts:

The original database instance from the sql server was deleted before I had
a chance to look at it..

I have tried to restore everything on another server but it is impossible to
get the records the user says are missing since the 18th of August.
The 18th of August backup can be restored without problem. I then tried to
restore the transaction log on to that but it did not help.

I have also brought up the old mdf and ldf file in a new instance, then
backed up the ldf (log) file and tried to resore it with point in time
recovery to both that instance and the instance from the old backup.
Neither effort yielded any new records since the 18th of August.

If anyone can give me information on how to get these records back (the ones
inserted since the 18th) I would appreciate it.

Right now, it does not look very good.

Thanks,

Steve K.

SQL Server55  
 
 
Thomas





PostPosted: Mon Sep 29 13:21:42 CDT 2003 Top

SQL Server >> Restore Steve:

Not sure what version of SQL Server you are using but it
has been my experience that unless you have all the files
from 8/18/03 forward you will not be able to perform a
restore to 9/29/03. You must have the database backup and
all of the transaction log file backups that are in
between.

I am afraid your success will end with the 8/18/03 backup.

Thomas
>-----Original Message-----
>Hello:
>
>We had a user/administrator here make a mistake.
>
>What I have is the following:
>
>1. A backup from August 18th
>2. An mdf file and an ldf file from Sept 23rd
>
>Facts:
>
>The original database instance from the sql server was
deleted before I had
>a chance to look at it..
>
>I have tried to restore everything on another server but
it is impossible to
>get the records the user says are missing since the 18th
of August.
>The 18th of August backup can be restored without
problem. I then tried to
>restore the transaction log on to that but it did not
help.
>
>I have also brought up the old mdf and ldf file in a new
instance, then
>backed up the ldf (log) file and tried to resore it with
point in time
>recovery to both that instance and the instance from the
old backup.
>Neither effort yielded any new records since the 18th of
August.
>
>If anyone can give me information on how to get these
records back (the ones
>inserted since the 18th) I would appreciate it.
>
>Right now, it does not look very good.
>
>Thanks,
>
>Steve K.
>
>
>.
>
 
 
Steve





PostPosted: Mon Sep 29 15:39:32 CDT 2003 Top

SQL Server >> Restore Thanks Thomas:

I appreciate your thoughts and insight.

Steve K.




> Steve:
>
> Not sure what version of SQL Server you are using but it
> has been my experience that unless you have all the files
> from 8/18/03 forward you will not be able to perform a
> restore to 9/29/03. You must have the database backup and
> all of the transaction log file backups that are in
> between.
>
> I am afraid your success will end with the 8/18/03 backup.
>
> Thomas
> >-----Original Message-----
> >Hello:
> >
> >We had a user/administrator here make a mistake.
> >
> >What I have is the following:
> >
> >1. A backup from August 18th
> >2. An mdf file and an ldf file from Sept 23rd
> >
> >Facts:
> >
> >The original database instance from the sql server was
> deleted before I had
> >a chance to look at it..
> >
> >I have tried to restore everything on another server but
> it is impossible to
> >get the records the user says are missing since the 18th
> of August.
> >The 18th of August backup can be restored without
> problem. I then tried to
> >restore the transaction log on to that but it did not
> help.
> >
> >I have also brought up the old mdf and ldf file in a new
> instance, then
> >backed up the ldf (log) file and tried to resore it with
> point in time
> >recovery to both that instance and the instance from the
> old backup.
> >Neither effort yielded any new records since the 18th of
> August.
> >
> >If anyone can give me information on how to get these
> records back (the ones
> >inserted since the 18th) I would appreciate it.
> >
> >Right now, it does not look very good.
> >
> >Thanks,
> >
> >Steve K.
> >
> >
> >.
> >


 
 
Tibor





PostPosted: Tue Sep 30 01:54:26 CDT 2003 Top

SQL Server >> Restore To add to Thomas' post:

You cannot apply an ldf file to a database backup. You can, possibly attach the mdf and ldf from
Sept 23, provided that these were the only database files for the database at that time.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver



> Hello:
>
> We had a user/administrator here make a mistake.
>
> What I have is the following:
>
> 1. A backup from August 18th
> 2. An mdf file and an ldf file from Sept 23rd
>
> Facts:
>
> The original database instance from the sql server was deleted before I had
> a chance to look at it..
>
> I have tried to restore everything on another server but it is impossible to
> get the records the user says are missing since the 18th of August.
> The 18th of August backup can be restored without problem. I then tried to
> restore the transaction log on to that but it did not help.
>
> I have also brought up the old mdf and ldf file in a new instance, then
> backed up the ldf (log) file and tried to resore it with point in time
> recovery to both that instance and the instance from the old backup.
> Neither effort yielded any new records since the 18th of August.
>
> If anyone can give me information on how to get these records back (the ones
> inserted since the 18th) I would appreciate it.
>
> Right now, it does not look very good.
>
> Thanks,
>
> Steve K.
>
>


 
 
Steve





PostPosted: Tue Sep 30 02:58:39 CDT 2003 Top

SQL Server >> Restore Tibor,

Thanks, I did create the same database on another instance. Then I stopped
sql server, deleted the newly created mdf and ldf files, replaced those with
the files from the deleted instance, restarted sql server and the database
opened.

However, while the records from the 18th of August were there, the last
backup; none of the records inserted after that time were there.

From this recreation, I then wrote that transaction log to backup. I then
restored the 18th of August database and that 2nd transaction log backup
(just mentioned before) and I still cannot see any of the records after the
18th of August.

So, it appears either the records simply are not in this mdf and ldf file,
or they are there but bringing these two files back are useless.

An important question in regard to what you said Tibor:

Can I assume that if I can successfully attach the mdf and ldf files from
the 23rd of September, and the records since the 18th of August are not in
there, cannot be found, that they were never in there at all?

Thanks in advance for your help,

Steve K.





> To add to Thomas' post:
>
> You cannot apply an ldf file to a database backup. You can, possibly
attach the mdf and ldf from
> Sept 23, provided that these were the only database files for the database
at that time.
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>


> > Hello:
> >
> > We had a user/administrator here make a mistake.
> >
> > What I have is the following:
> >
> > 1. A backup from August 18th
> > 2. An mdf file and an ldf file from Sept 23rd
> >
> > Facts:
> >
> > The original database instance from the sql server was deleted before I
had
> > a chance to look at it..
> >
> > I have tried to restore everything on another server but it is
impossible to
> > get the records the user says are missing since the 18th of August.
> > The 18th of August backup can be restored without problem. I then tried
to
> > restore the transaction log on to that but it did not help.
> >
> > I have also brought up the old mdf and ldf file in a new instance, then
> > backed up the ldf (log) file and tried to resore it with point in time
> > recovery to both that instance and the instance from the old backup.
> > Neither effort yielded any new records since the 18th of August.
> >
> > If anyone can give me information on how to get these records back (the
ones
> > inserted since the 18th) I would appreciate it.
> >
> > Right now, it does not look very good.
> >
> > Thanks,
> >
> > Steve K.
> >
> >
>
>


 
 
Tibor





PostPosted: Tue Sep 30 09:04:14 CDT 2003 Top

SQL Server >> Restore > Thanks, I did create the same database on another instance. Then I stopped
> sql server, deleted the newly created mdf and ldf files, replaced those with
> the files from the deleted instance, restarted sql server and the database
> opened.

Why go through all this hoopla when you could quite simply try sp_attach_db? :-) From what date
were these files?

> However, while the records from the 18th of August were there, the last
> backup; none of the records inserted after that time were there.

I don't understand above. You keep talking about backup. Do you refer to SQL Server backups taken
using the SQL Server BACKUP command? I think I'll stop here as the rest of the text makes even less
sense to me and info is needed for that as well regarding whether you use SQL Server backup or
something else.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver



> Tibor,
>
> Thanks, I did create the same database on another instance. Then I stopped
> sql server, deleted the newly created mdf and ldf files, replaced those with
> the files from the deleted instance, restarted sql server and the database
> opened.
>
> However, while the records from the 18th of August were there, the last
> backup; none of the records inserted after that time were there.
>
> From this recreation, I then wrote that transaction log to backup. I then
> restored the 18th of August database and that 2nd transaction log backup
> (just mentioned before) and I still cannot see any of the records after the
> 18th of August.
>
> So, it appears either the records simply are not in this mdf and ldf file,
> or they are there but bringing these two files back are useless.
>
> An important question in regard to what you said Tibor:
>
> Can I assume that if I can successfully attach the mdf and ldf files from
> the 23rd of September, and the records since the 18th of August are not in
> there, cannot be found, that they were never in there at all?
>
> Thanks in advance for your help,
>
> Steve K.
>
>
>


> > To add to Thomas' post:
> >
> > You cannot apply an ldf file to a database backup. You can, possibly
> attach the mdf and ldf from
> > Sept 23, provided that these were the only database files for the database
> at that time.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >


> > > Hello:
> > >
> > > We had a user/administrator here make a mistake.
> > >
> > > What I have is the following:
> > >
> > > 1. A backup from August 18th
> > > 2. An mdf file and an ldf file from Sept 23rd
> > >
> > > Facts:
> > >
> > > The original database instance from the sql server was deleted before I
> had
> > > a chance to look at it..
> > >
> > > I have tried to restore everything on another server but it is
> impossible to
> > > get the records the user says are missing since the 18th of August.
> > > The 18th of August backup can be restored without problem. I then tried
> to
> > > restore the transaction log on to that but it did not help.
> > >
> > > I have also brought up the old mdf and ldf file in a new instance, then
> > > backed up the ldf (log) file and tried to resore it with point in time
> > > recovery to both that instance and the instance from the old backup.
> > > Neither effort yielded any new records since the 18th of August.
> > >
> > > If anyone can give me information on how to get these records back (the
> ones
> > > inserted since the 18th) I would appreciate it.
> > >
> > > Right now, it does not look very good.
> > >
> > > Thanks,
> > >
> > > Steve K.
> > >
> > >
> >
> >
>
>


 
 
Steve





PostPosted: Tue Sep 30 18:35:00 CDT 2003 Top

SQL Server >> Restore Sorry Tibor, here is the correct order of events that one of our
administrators has apparently done, and what I am left with:

1. August 18th, backup done.
2. September 23, administrator has trouble with the database, have no idea
what happened and he cannot really explain, possibly no space left on the
disk.
3. Admin does not take a backup. And there are no backups between the Aug
19th and Sept 23rd.
4. Admin copies, on Sept 23rd, the mdf and ldf files to another location
after shutting down the database.
5. Admin then restarts sql server and deletes the database.

What do I have?
1. one good backup from the 18th of August
2. one mdf and ldf file from the 23rd of September.

Thanks, if you can give me an idea of what to do I would appreciate it.
Hope this is more clear.

Best regards,

Steve K.






> > Thanks, I did create the same database on another instance. Then I
stopped
> > sql server, deleted the newly created mdf and ldf files, replaced those
with
> > the files from the deleted instance, restarted sql server and the
database
> > opened.
>
> Why go through all this hoopla when you could quite simply try
sp_attach_db? :-) From what date
> were these files?
>
> > However, while the records from the 18th of August were there, the last
> > backup; none of the records inserted after that time were there.
>
> I don't understand above. You keep talking about backup. Do you refer to
SQL Server backups taken
> using the SQL Server BACKUP command? I think I'll stop here as the rest of
the text makes even less
> sense to me and info is needed for that as well regarding whether you use
SQL Server backup or
> something else.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>


> > Tibor,
> >
> > Thanks, I did create the same database on another instance. Then I
stopped
> > sql server, deleted the newly created mdf and ldf files, replaced those
with
> > the files from the deleted instance, restarted sql server and the
database
> > opened.
> >
> > However, while the records from the 18th of August were there, the last
> > backup; none of the records inserted after that time were there.
> >
> > From this recreation, I then wrote that transaction log to backup. I
then
> > restored the 18th of August database and that 2nd transaction log backup
> > (just mentioned before) and I still cannot see any of the records after
the
> > 18th of August.
> >
> > So, it appears either the records simply are not in this mdf and ldf
file,
> > or they are there but bringing these two files back are useless.
> >
> > An important question in regard to what you said Tibor:
> >
> > Can I assume that if I can successfully attach the mdf and ldf files
from
> > the 23rd of September, and the records since the 18th of August are not
in
> > there, cannot be found, that they were never in there at all?
> >
> > Thanks in advance for your help,
> >
> > Steve K.
> >
> >
> >
> > "Tibor Karaszi"


> > > To add to Thomas' post:
> > >
> > > You cannot apply an ldf file to a database backup. You can, possibly
> > attach the mdf and ldf from
> > > Sept 23, provided that these were the only database files for the
database
> > at that time.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > Archive at: http://groups.google.com/groups?oi=djq&as
> > ugroup=microsoft.public.sqlserver
> > >
> > >


> > > > Hello:
> > > >
> > > > We had a user/administrator here make a mistake.
> > > >
> > > > What I have is the following:
> > > >
> > > > 1. A backup from August 18th
> > > > 2. An mdf file and an ldf file from Sept 23rd
> > > >
> > > > Facts:
> > > >
> > > > The original database instance from the sql server was deleted
before I
> > had
> > > > a chance to look at it..
> > > >
> > > > I have tried to restore everything on another server but it is
> > impossible to
> > > > get the records the user says are missing since the 18th of August.
> > > > The 18th of August backup can be restored without problem. I then
tried
> > to
> > > > restore the transaction log on to that but it did not help.
> > > >
> > > > I have also brought up the old mdf and ldf file in a new instance,
then
> > > > backed up the ldf (log) file and tried to resore it with point in
time
> > > > recovery to both that instance and the instance from the old backup.
> > > > Neither effort yielded any new records since the 18th of August.
> > > >
> > > > If anyone can give me information on how to get these records back
(the
> > ones
> > > > inserted since the 18th) I would appreciate it.
> > > >
> > > > Right now, it does not look very good.
> > > >
> > > > Thanks,
> > > >
> > > > Steve K.
> > > >
> > > >
> > >
> > >
> >
> >
>
>


 
 
Steve





PostPosted: Tue Sep 30 18:36:05 CDT 2003 Top

SQL Server >> Restore one last thing, the backups, actually backup (there is just one from the
18th of August, was taken using SQL Server.

Thanks again,

Steve K.




> > Thanks, I did create the same database on another instance. Then I
stopped
> > sql server, deleted the newly created mdf and ldf files, replaced those
with
> > the files from the deleted instance, restarted sql server and the
database
> > opened.
>
> Why go through all this hoopla when you could quite simply try
sp_attach_db? :-) From what date
> were these files?
>
> > However, while the records from the 18th of August were there, the last
> > backup; none of the records inserted after that time were there.
>
> I don't understand above. You keep talking about backup. Do you refer to
SQL Server backups taken
> using the SQL Server BACKUP command? I think I'll stop here as the rest of
the text makes even less
> sense to me and info is needed for that as well regarding whether you use
SQL Server backup or
> something else.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>


> > Tibor,
> >
> > Thanks, I did create the same database on another instance. Then I
stopped
> > sql server, deleted the newly created mdf and ldf files, replaced those
with
> > the files from the deleted instance, restarted sql server and the
database
> > opened.
> >
> > However, while the records from the 18th of August were there, the last
> > backup; none of the records inserted after that time were there.
> >
> > From this recreation, I then wrote that transaction log to backup. I
then
> > restored the 18th of August database and that 2nd transaction log backup
> > (just mentioned before) and I still cannot see any of the records after
the
> > 18th of August.
> >
> > So, it appears either the records simply are not in this mdf and ldf
file,
> > or they are there but bringing these two files back are useless.
> >
> > An important question in regard to what you said Tibor:
> >
> > Can I assume that if I can successfully attach the mdf and ldf files
from
> > the 23rd of September, and the records since the 18th of August are not
in
> > there, cannot be found, that they were never in there at all?
> >
> > Thanks in advance for your help,
> >
> > Steve K.
> >
> >
> >
> > "Tibor Karaszi"


> > > To add to Thomas' post:
> > >
> > > You cannot apply an ldf file to a database backup. You can, possibly
> > attach the mdf and ldf from
> > > Sept 23, provided that these were the only database files for the
database
> > at that time.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > Archive at: http://groups.google.com/groups?oi=djq&as
> > ugroup=microsoft.public.sqlserver
> > >
> > >


> > > > Hello:
> > > >
> > > > We had a user/administrator here make a mistake.
> > > >
> > > > What I have is the following:
> > > >
> > > > 1. A backup from August 18th
> > > > 2. An mdf file and an ldf file from Sept 23rd
> > > >
> > > > Facts:
> > > >
> > > > The original database instance from the sql server was deleted
before I
> > had
> > > > a chance to look at it..
> > > >
> > > > I have tried to restore everything on another server but it is
> > impossible to
> > > > get the records the user says are missing since the 18th of August.
> > > > The 18th of August backup can be restored without problem. I then
tried
> > to
> > > > restore the transaction log on to that but it did not help.
> > > >
> > > > I have also brought up the old mdf and ldf file in a new instance,
then
> > > > backed up the ldf (log) file and tried to resore it with point in
time
> > > > recovery to both that instance and the instance from the old backup.
> > > > Neither effort yielded any new records since the 18th of August.
> > > >
> > > > If anyone can give me information on how to get these records back
(the
> > ones
> > > > inserted since the 18th) I would appreciate it.
> > > >
> > > > Right now, it does not look very good.
> > > >
> > > > Thanks,
> > > >
> > > > Steve K.
> > > >
> > > >
> > >
> > >
> >
> >
>
>


 
 
Tibor





PostPosted: Wed Oct 01 06:37:03 CDT 2003 Top

SQL Server >> Restore OK, so it seems you have a SQL Server backup (.BAK) taken Aug 18 and nothing from then on (except a
couple of copied file from Sept 23).

If you attach the sept 23 files, is all OK?
Or was the problem introduced between Aug 18 and Sept 23?
Or do you want to get stuff backup from *after* Sept 23?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver



> Sorry Tibor, here is the correct order of events that one of our
> administrators has apparently done, and what I am left with:
>
> 1. August 18th, backup done.
> 2. September 23, administrator has trouble with the database, have no idea
> what happened and he cannot really explain, possibly no space left on the
> disk.
> 3. Admin does not take a backup. And there are no backups between the Aug
> 19th and Sept 23rd.
> 4. Admin copies, on Sept 23rd, the mdf and ldf files to another location
> after shutting down the database.
> 5. Admin then restarts sql server and deletes the database.
>
> What do I have?
> 1. one good backup from the 18th of August
> 2. one mdf and ldf file from the 23rd of September.
>
> Thanks, if you can give me an idea of what to do I would appreciate it.
> Hope this is more clear.
>
> Best regards,
>
> Steve K.
>
>
>
>


> > > Thanks, I did create the same database on another instance. Then I
> stopped
> > > sql server, deleted the newly created mdf and ldf files, replaced those
> with
> > > the files from the deleted instance, restarted sql server and the
> database
> > > opened.
> >
> > Why go through all this hoopla when you could quite simply try
> sp_attach_db? :-) From what date
> > were these files?
> >
> > > However, while the records from the 18th of August were there, the last
> > > backup; none of the records inserted after that time were there.
> >
> > I don't understand above. You keep talking about backup. Do you refer to
> SQL Server backups taken
> > using the SQL Server BACKUP command? I think I'll stop here as the rest of
> the text makes even less
> > sense to me and info is needed for that as well regarding whether you use
> SQL Server backup or
> > something else.
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >


> > > Tibor,
> > >
> > > Thanks, I did create the same database on another instance. Then I
> stopped
> > > sql server, deleted the newly created mdf and ldf files, replaced those
> with
> > > the files from the deleted instance, restarted sql server and the
> database
> > > opened.
> > >
> > > However, while the records from the 18th of August were there, the last
> > > backup; none of the records inserted after that time were there.
> > >
> > > From this recreation, I then wrote that transaction log to backup. I
> then
> > > restored the 18th of August database and that 2nd transaction log backup
> > > (just mentioned before) and I still cannot see any of the records after
> the
> > > 18th of August.
> > >
> > > So, it appears either the records simply are not in this mdf and ldf
> file,
> > > or they are there but bringing these two files back are useless.
> > >
> > > An important question in regard to what you said Tibor:
> > >
> > > Can I assume that if I can successfully attach the mdf and ldf files
> from
> > > the 23rd of September, and the records since the 18th of August are not
> in
> > > there, cannot be found, that they were never in there at all?
> > >
> > > Thanks in advance for your help,
> > >
> > > Steve K.
> > >
> > >
> > >
> > > "Tibor Karaszi"


> > > > To add to Thomas' post:
> > > >
> > > > You cannot apply an ldf file to a database backup. You can, possibly
> > > attach the mdf and ldf from
> > > > Sept 23, provided that these were the only database files for the
> database
> > > at that time.
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > Archive at: http://groups.google.com/groups?oi=djq&as
> > > ugroup=microsoft.public.sqlserver
> > > >
> > > >


> > > > > Hello:
> > > > >
> > > > > We had a user/administrator here make a mistake.
> > > > >
> > > > > What I have is the following:
> > > > >
> > > > > 1. A backup from August 18th
> > > > > 2. An mdf file and an ldf file from Sept 23rd
> > > > >
> > > > > Facts:
> > > > >
> > > > > The original database instance from the sql server was deleted
> before I
> > > had
> > > > > a chance to look at it..
> > > > >
> > > > > I have tried to restore everything on another server but it is
> > > impossible to
> > > > > get the records the user says are missing since the 18th of August.
> > > > > The 18th of August backup can be restored without problem. I then
> tried
> > > to
> > > > > restore the transaction log on to that but it did not help.
> > > > >
> > > > > I have also brought up the old mdf and ldf file in a new instance,
> then
> > > > > backed up the ldf (log) file and tried to resore it with point in
> time
> > > > > recovery to both that instance and the instance from the old backup.
> > > > > Neither effort yielded any new records since the 18th of August.
> > > > >
> > > > > If anyone can give me information on how to get these records back
> (the
> > > ones
> > > > > inserted since the 18th) I would appreciate it.
> > > > >
> > > > > Right now, it does not look very good.
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Steve K.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>