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
> >
> >
> >.
> >