Backup Problem

I back up our database on a monthly basis and just recently the server had
to be upgraded and rebooted. It seems as though some data was lost.
When restarting does the database return to its orginal state or a previous
backed up version?
ThanksHello Donald !
Uncommited transaction are only rollbacked if you restart the server.
Why do think there is data lost ? Are there any hints ?
Jens Süßmeyer.
"Donald Harman" <donald.harman@.payglobal.com> schrieb im Newsbeitrag
news:##kAupgZDHA.656@.tk2msftngp13.phx.gbl...
> I back up our database on a monthly basis and just recently the server had
> to be upgraded and rebooted. It seems as though some data was lost.
> When restarting does the database return to its orginal state or a
previous
> backed up version?
> Thanks
>|||No clues,
I am relatively new to SQL Server and all should be smooth as just an entry
that should be in there no longer is.
I was wondering if by some weird reason the Database may have restarted and
restored an older
backed up version.
At this stage am none the wiser.
Still am able to restore data with a manual entry.
All is not lost but ? only '.
joys
thanks for your help
"Jens Süßmeyer" <jsuessmeyer@.[REJECT_SPAM]web.de> wrote in message
news:e3hchIhZDHA.2960@.tk2msftngp13.phx.gbl...
> Hello Donald !
> Uncommited transaction are only rollbacked if you restart the server.
> Why do think there is data lost ? Are there any hints ?
> Jens Süßmeyer.
> "Donald Harman" <donald.harman@.payglobal.com> schrieb im Newsbeitrag
> news:##kAupgZDHA.656@.tk2msftngp13.phx.gbl...
> > I back up our database on a monthly basis and just recently the server
had
> > to be upgraded and rebooted. It seems as though some data was lost.
> >
> > When restarting does the database return to its orginal state or a
> previous
> > backed up version?
> >
> > Thanks
> >
> >
>|||> I was wondering if by some weird reason the Database may have restarted and
> restored an older
> backed up version.
SQL Server doesn't do this. It does, however, rollback uncommitted transactions at startup, as
posted by Jens. It is very difficult to assist these cases "over the net". You might want to get
someone experienced with SQL Server to have a look at the machine. Or give a detailed post about
what has happened and how you determine your loss of data.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Donald Harman" <donald.harman@.payglobal.com> wrote in message
news:eG9$GShZDHA.2256@.TK2MSFTNGP10.phx.gbl...
> No clues,
> I am relatively new to SQL Server and all should be smooth as just an entry
> that should be in there no longer is.
> I was wondering if by some weird reason the Database may have restarted and
> restored an older
> backed up version.
> At this stage am none the wiser.
> Still am able to restore data with a manual entry.
> All is not lost but ? only '.
> joys
> thanks for your help
> "Jens Süßmeyer" <jsuessmeyer@.[REJECT_SPAM]web.de> wrote in message
> news:e3hchIhZDHA.2960@.tk2msftngp13.phx.gbl...
> > Hello Donald !
> >
> > Uncommited transaction are only rollbacked if you restart the server.
> > Why do think there is data lost ? Are there any hints ?
> >
> > Jens Süßmeyer.
> >
> > "Donald Harman" <donald.harman@.payglobal.com> schrieb im Newsbeitrag
> > news:##kAupgZDHA.656@.tk2msftngp13.phx.gbl...
> > > I back up our database on a monthly basis and just recently the server
> had
> > > to be upgraded and rebooted. It seems as though some data was lost.
> > >
> > > When restarting does the database return to its orginal state or a
> > previous
> > > backed up version?
> > >
> > > Thanks
> > >
> > >
> >
> >
>