Backup file database was restored from

Hello!
I am trying to find out name of the backup file database was restored from
(I am restoring from DISK), something similar to physical_device_name in
backupmediafamily. restorehistory doesn't have this information.
Any advice is greatly appreciated.
Thanks,
Igor
You can use backup_set_id on restorehistory and media_set_id on backupset to
find the record on backupmediafamily.
Hope this helps,
Ben Nevarez
"Igor Marchenko" wrote:

> Hello!
> I am trying to find out name of the backup file database was restored from
> (I am restoring from DISK), something similar to physical_device_name in
> backupmediafamily. restorehistory doesn't have this information.
> Any advice is greatly appreciated.
> Thanks,
> Igor
|||Thanks a lot Ben! That exactly what I was looking for.
Igor
"Ben Nevarez" wrote:
[vbcol=seagreen]
> You can use backup_set_id on restorehistory and media_set_id on backupset to
> find the record on backupmediafamily.
> Hope this helps,
> Ben Nevarez
>
>
> "Igor Marchenko" wrote:
sql

Backup file database was restored from

Hello!
I am trying to find out name of the backup file database was restored from
(I am restoring from DISK), something similar to physical_device_name in
backupmediafamily. restorehistory doesn't have this information.
Any advice is greatly appreciated.
Thanks,
IgorYou can use backup_set_id on restorehistory and media_set_id on backupset to
find the record on backupmediafamily.
Hope this helps,
Ben Nevarez
"Igor Marchenko" wrote:
> Hello!
> I am trying to find out name of the backup file database was restored from
> (I am restoring from DISK), something similar to physical_device_name in
> backupmediafamily. restorehistory doesn't have this information.
> Any advice is greatly appreciated.
> Thanks,
> Igor|||Thanks a lot Ben! That exactly what I was looking for.
Igor
"Ben Nevarez" wrote:
> You can use backup_set_id on restorehistory and media_set_id on backupset to
> find the record on backupmediafamily.
> Hope this helps,
> Ben Nevarez
>
>
> "Igor Marchenko" wrote:
> > Hello!
> >
> > I am trying to find out name of the backup file database was restored from
> > (I am restoring from DISK), something similar to physical_device_name in
> > backupmediafamily. restorehistory doesn't have this information.
> > Any advice is greatly appreciated.
> >
> > Thanks,
> > Igor

Backup didn't contain last 8 hours of data

By some for me unknown reason my backup didn't contain
the last 8 hours of data when I restored them. However
the data was in the detached files that I also copied
directly after I backed up the databases. There where no
user except me while performing this operation.
Anyone had problems like this? I thought that a backup
should write all data from the DB's to the devices.
(Recovery model simple and no pending transaction on the
DB's.)
//LEBAre you sure that restore the correct backup? Perhaps you didn't specify NOINIT for the backup and
when restore didn't specify the FILE parameter -> restored an earlier backup.
I have never seen or heard about SQL Server not including the committed transactions in a database
backup. Nor can I see how that can happen architecturally.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"LEB" <lars-erik.blom@.tuesday.se> wrote in message news:09b701c36dfb$496e7360$a301280a@.phx.gbl...
> By some for me unknown reason my backup didn't contain
> the last 8 hours of data when I restored them. However
> the data was in the detached files that I also copied
> directly after I backed up the databases. There where no
> user except me while performing this operation.
> Anyone had problems like this? I thought that a backup
> should write all data from the DB's to the devices.
> (Recovery model simple and no pending transaction on the
> DB's.)
> //LEB|||Neither does me. Since I can see that the DB device is
created at the time when I did the backup I'm sure that
the file is the proper one. I scratched the previous to
be sure. I also specified different file locations, new
since I rebuild the server. As seen from a technical
standpoint there is not a failure running this. The
backup and restore runs smoothly without errors. I've
never been this confused regarding backup/restore before.
Suggestions?
//LEB
>--Original Message--
>Are you sure that restore the correct backup? Perhaps
you didn't specify NOINIT for the backup and
>when restore didn't specify the FILE parameter ->
restored an earlier backup.
>I have never seen or heard about SQL Server not
including the committed transactions in a database
>backup. Nor can I see how that can happen
architecturally.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>"LEB" <lars-erik.blom@.tuesday.se> wrote in message
news:09b701c36dfb$496e7360$a301280a@.phx.gbl...
>> By some for me unknown reason my backup didn't contain
>> the last 8 hours of data when I restored them. However
>> the data was in the detached files that I also copied
>> directly after I backed up the databases. There where
no
>> user except me while performing this operation.
>> Anyone had problems like this? I thought that a backup
>> should write all data from the DB's to the devices.
>> (Recovery model simple and no pending transaction on
the
>> DB's.)
>> //LEB
>
>.
>|||The only last thing I can think of is RESTORE HEADERONLY to be 100% certain...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"LEB" <lars-erik.blom@.tuesday.se> wrote in message news:037c01c36e19$96b70380$a001280a@.phx.gbl...
> Neither does me. Since I can see that the DB device is
> created at the time when I did the backup I'm sure that
> the file is the proper one. I scratched the previous to
> be sure. I also specified different file locations, new
> since I rebuild the server. As seen from a technical
> standpoint there is not a failure running this. The
> backup and restore runs smoothly without errors. I've
> never been this confused regarding backup/restore before.
> Suggestions?
> //LEB
> >--Original Message--
> >Are you sure that restore the correct backup? Perhaps
> you didn't specify NOINIT for the backup and
> >when restore didn't specify the FILE parameter ->
> restored an earlier backup.
> >I have never seen or heard about SQL Server not
> including the committed transactions in a database
> >backup. Nor can I see how that can happen
> architecturally.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> >"LEB" <lars-erik.blom@.tuesday.se> wrote in message
> news:09b701c36dfb$496e7360$a301280a@.phx.gbl...
> >> By some for me unknown reason my backup didn't contain
> >> the last 8 hours of data when I restored them. However
> >> the data was in the detached files that I also copied
> >> directly after I backed up the databases. There where
> no
> >> user except me while performing this operation.
> >> Anyone had problems like this? I thought that a backup
> >> should write all data from the DB's to the devices.
> >> (Recovery model simple and no pending transaction on
> the
> >> DB's.)
> >>
> >> //LEB
> >
> >
> >.
> >

Backup / restore question

I had a SQL server with some harddrive problems. So, a full backup was made
(manually using Enterprise Manager) and restored in a new machine
successfully using Enterprise Manager (the option Leave Database
Operational. No Additional Transaction Logs Can Be Restored was selected)
If the only backup available is the last Full backup, is it possible to ever
roll back some of the last changes made in the old machine before the Full
Backup ?
Thanks for your help.If all you have is the full backup and the old db is toast then no. You
might be able to do something with third party tool help such as Lumigent
Log Explorer depending on a few factors.
Ray Higdon MCSE, MCDBA, CCNA
--
<--> wrote in message news:%23xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> I had a SQL server with some harddrive problems. So, a full backup was
made
> (manually using Enterprise Manager) and restored in a new machine
> successfully using Enterprise Manager (the option Leave Database
> Operational. No Additional Transaction Logs Can Be Restored was selected)
> If the only backup available is the last Full backup, is it possible to
ever
> roll back some of the last changes made in the old machine before the Full
> Backup ?
> Thanks for your help.
>|||Hi,
You can do this only if your OLD database is in "FULL" recovery model. Below
steps are under the assumption
that database was set to FULL recovery model and the existing database is
still up.
1. In the new server Load the full database backup with NORECOVERY
2. Perform a transaction log backup in Old Server.
3. Copy the TX log backup file to new server
4. Restore the Transaction log WITH RECOVERY , STOPAT='DATE/TIME (refer
Books online)
This will allow you to go back to old data based on the date and time.
Note:
If it is Simple or Bulk_logged recovery model you cant rollback.
POINT-IN-TIME recovery is not supposed in both.
Thanks
Hari
MCDBA
<--> wrote in message news:#xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> I had a SQL server with some harddrive problems. So, a full backup was
made
> (manually using Enterprise Manager) and restored in a new machine
> successfully using Enterprise Manager (the option Leave Database
> Operational. No Additional Transaction Logs Can Be Restored was selected)
> If the only backup available is the last Full backup, is it possible to
ever
> roll back some of the last changes made in the old machine before the Full
> Backup ?
> Thanks for your help.
>|||Hi Hari,
Unfortunately, my old server's HD is no longer is functioning. And all I
have is the last Full Backup. Looks like I may not be able to rollback any
changes...
Can you confirm?
Thanks.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:u4QLTU$AEHA.1456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> You can do this only if your OLD database is in "FULL" recovery model.
Below
> steps are under the assumption
> that database was set to FULL recovery model and the existing database is
> still up.
> 1. In the new server Load the full database backup with NORECOVERY
> 2. Perform a transaction log backup in Old Server.
> 3. Copy the TX log backup file to new server
> 4. Restore the Transaction log WITH RECOVERY , STOPAT='DATE/TIME (refer
> Books online)
> This will allow you to go back to old data based on the date and time.
> Note:
> If it is Simple or Bulk_logged recovery model you cant rollback.
> POINT-IN-TIME recovery is not supposed in both.
> Thanks
> Hari
> MCDBA
>
>
>
> <--> wrote in message news:#xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> made
selected)
> ever
Full
>|||You will not be able to rollback any changes, as Hari pointed out you can
only do point in time recovery by using the tran log
Ray Higdon MCSE, MCDBA, CCNA
--
<--> wrote in message news:O1pe8EFBEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi Hari,
> Unfortunately, my old server's HD is no longer is functioning. And all I
> have is the last Full Backup. Looks like I may not be able to rollback
any
> changes...
> Can you confirm?
> Thanks.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:u4QLTU$AEHA.1456@.TK2MSFTNGP09.phx.gbl...
> Below
is
was
> selected)
to
> Full
>|||Hi,
If you dont have the old database active, Sorry, you will not be able to
rollback the transactions (POINT-IN-TIME).
Thanks
Hari
MCDBA
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> wrote in message
news:#vsd8lFBEHA.1600@.tk2msftngp13.phx.gbl...
> You will not be able to rollback any changes, as Hari pointed out you can
> only do point in time recovery by using the tran log
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> <--> wrote in message news:O1pe8EFBEHA.2600@.TK2MSFTNGP09.phx.gbl...
> any
> is
(refer
> was
> to
the
>