"frank" <anonymous@discussions.microsoft.com> wrote in message
news:FE632019-4F4A-413D-8EEC-AE856AEC9760@microsoft.com...
> in work , I usually use full backup .
> i think file backup will be more useful ,but the information of it is
rare .
> if anyone use it before .

"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:O0F5aU5GEHA.2840@TK2MSFTNGP10.phx.gbl...
> Hi Frank,
>
> If your data is not that critical and the database size is not that hge
> (less than 2 GB) you can perfom a FULL database backup daily once.
> If the data is ver critical set the database to "FULL" recovery model and
> perform a Transaction log backup. This will help you to recover the datase
> till POINT-IN-TIME in the event of crash.
>
> For more information check Recovery models in books online.
>
> Thanks
> Hari
> MCDBA
>
> "frank" <anonymous@discussions.microsoft.com> wrote in message
> news:FE632019-4F4A-413D-8EEC-AE856AEC9760@microsoft.com...
> > in work , I usually use full backup .
> > i think file backup will be more useful ,but the information of it is
> rare .
> > if anyone use it before .
>
>

"Noorali Issani" <naissani@softhome.net> wrote in message
news:O251BZ6GEHA.2392@tk2msftngp13.phx.gbl...
> Hari, can you tell me about
>
> "This will help you to recover the datase
> till POINT-IN-TIME in the event of crash."
>
> How ? like let's assume I took the log file back before 2 hours and my
> database gone crashed, how can I do POINT-IN-TIME recovery.
>
> Thanks in advance Hari
> Noor
>
>
> "Hari" <hari_prasad_k@hotmail.com> wrote in message
> news:O0F5aU5GEHA.2840@TK2MSFTNGP10.phx.gbl...
> > Hi Frank,
> >
> > If your data is not that critical and the database size is not that hge
> > (less than 2 GB) you can perfom a FULL database backup daily once.
> > If the data is ver critical set the database to "FULL" recovery model
and
> > perform a Transaction log backup. This will help you to recover the
datase
> > till POINT-IN-TIME in the event of crash.
> >
> > For more information check Recovery models in books online.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "frank" <anonymous@discussions.microsoft.com> wrote in message
> > news:FE632019-4F4A-413D-8EEC-AE856AEC9760@microsoft.com...
> > > in work , I usually use full backup .
> > > i think file backup will be more useful ,but the information of it is
> > rare .
> > > if anyone use it before .
> >
> >
>
>

"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:eM83nl6GEHA.2084@TK2MSFTNGP10.phx.gbl...
> Hi Noor,
>
> POINT-IN-TIME means recover database to a specific point of time.
>
> Say you have a Finance database, You have transaction log backup till 10
AM.
>
> At 10:15 AM, an user did a wrong updates, instead of putting 10% discount
he
> made 15% and did the processing and records got commited. In this case if
> you have a FULL recovery model set to that database you can recover till
> 10:14 AM.
>
> Steps:
>
> 1. Perform a Transaction log backup at 10:15 AM on your real database.
> 2. Restore the full database backup to a new database with norecovery
> 3. Restore the subsequent transaction log backups (in the order of backup
> taken)with NORECOVERY till the backup taken in step1
> 4. Restore the last transaction log backup (taken in step.1 with RECOVERY
> and STOPAT option with date and time (Say in yor case 10:14 AM).
>
> Now you have got a new database with data till 10:14 AM.
>
> Thanks
> Hari
> MCDBA
>
>
>
>
> "Noorali Issani" <naissani@softhome.net> wrote in message
> news:O251BZ6GEHA.2392@tk2msftngp13.phx.gbl...
> > Hari, can you tell me about
> >
> > "This will help you to recover the datase
> > till POINT-IN-TIME in the event of crash."
> >
> > How ? like let's assume I took the log file back before 2 hours and my
> > database gone crashed, how can I do POINT-IN-TIME recovery.
> >
> > Thanks in advance Hari
> > Noor
> >
> >
> > "Hari" <hari_prasad_k@hotmail.com> wrote in message
> > news:O0F5aU5GEHA.2840@TK2MSFTNGP10.phx.gbl...
> > > Hi Frank,
> > >
> > > If your data is not that critical and the database size is not that
hge
> > > (less than 2 GB) you can perfom a FULL database backup daily once.
> > > If the data is ver critical set the database to "FULL" recovery model
> and
> > > perform a Transaction log backup. This will help you to recover the
> datase
> > > till POINT-IN-TIME in the event of crash.
> > >
> > > For more information check Recovery models in books online.
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > > "frank" <anonymous@discussions.microsoft.com> wrote in message
> > > news:FE632019-4F4A-413D-8EEC-AE856AEC9760@microsoft.com...
> > > > in work , I usually use full backup .
> > > > i think file backup will be more useful ,but the information of it
is
> > > rare .
> > > > if anyone use it before .
> > >
> > >
> >
> >
>
>

"Noorali Issani" <naissani@softhome.net> wrote in message
news:eiQaZH7GEHA.128@tk2msftngp13.phx.gbl...
> Thanks Hari, I have a question here.. it means the backup log also
maintain
> the log with date and time righto.. ?
>
> I am taking your example like I took last backup of log file around 10:15
> and my database has crashed at 11:00, Is there any way how can I get the
dml
> records which incured in between 10:15 to 11:00., If yes then how ?
>
> Thanks
> NOOR
>
> "Hari" <hari_prasad_k@hotmail.com> wrote in message
> news:eM83nl6GEHA.2084@TK2MSFTNGP10.phx.gbl...
> > Hi Noor,
> >
> > POINT-IN-TIME means recover database to a specific point of time.
> >
> > Say you have a Finance database, You have transaction log backup till 10
> AM.
> >
> > At 10:15 AM, an user did a wrong updates, instead of putting 10%
discount
> he
> > made 15% and did the processing and records got commited. In this case
if
> > you have a FULL recovery model set to that database you can recover till
> > 10:14 AM.
> >
> > Steps:
> >
> > 1. Perform a Transaction log backup at 10:15 AM on your real database.
> > 2. Restore the full database backup to a new database with norecovery
> > 3. Restore the subsequent transaction log backups (in the order of
backup
> > taken)with NORECOVERY till the backup taken in step1
> > 4. Restore the last transaction log backup (taken in step.1 with
RECOVERY
> > and STOPAT option with date and time (Say in yor case 10:14 AM).
> >
> > Now you have got a new database with data till 10:14 AM.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> > "Noorali Issani" <naissani@softhome.net> wrote in message
> > news:O251BZ6GEHA.2392@tk2msftngp13.phx.gbl...
> > > Hari, can you tell me about
> > >
> > > "This will help you to recover the datase
> > > till POINT-IN-TIME in the event of crash."
> > >
> > > How ? like let's assume I took the log file back before 2 hours and my
> > > database gone crashed, how can I do POINT-IN-TIME recovery.
> > >
> > > Thanks in advance Hari
> > > Noor
> > >
> > >
> > > "Hari" <hari_prasad_k@hotmail.com> wrote in message
> > > news:O0F5aU5GEHA.2840@TK2MSFTNGP10.phx.gbl...
> > > > Hi Frank,
> > > >
> > > > If your data is not that critical and the database size is not that
> hge
> > > > (less than 2 GB) you can perfom a FULL database backup daily once.
> > > > If the data is ver critical set the database to "FULL" recovery
model
> > and
> > > > perform a Transaction log backup. This will help you to recover the
> > datase
> > > > till POINT-IN-TIME in the event of crash.
> > > >
> > > > For more information check Recovery models in books online.
> > > >
> > > > Thanks
> > > > Hari
> > > > MCDBA
> > > >
> > > > "frank" <anonymous@discussions.microsoft.com> wrote in message
> > > > news:FE632019-4F4A-413D-8EEC-AE856AEC9760@microsoft.com...
> > > > > in work , I usually use full backup .
> > > > > i think file backup will be more useful ,but the information of
it
> is
> > > > rare .
> > > > > if anyone use it before .
> > > >
> > > >
> > >
> > >
> >
> >
>
>

"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:%23pNPet7GEHA.740@tk2msftngp13.phx.gbl...
> Hi,
>
> In your case if the database is totally crashed including the physical
files
> then you can recover only till 10:15 ,
> provided that your Full database backup and Transaction log backup files
are
> safe. This case you can only recover the database
> till the last transaction log backup (10:15).
>
> Thanks
> Hari
> MCDBA
>
>
> "Noorali Issani" <naissani@softhome.net> wrote in message
> news:eiQaZH7GEHA.128@tk2msftngp13.phx.gbl...
> > Thanks Hari, I have a question here.. it means the backup log also
> maintain
> > the log with date and time righto.. ?
> >
> > I am taking your example like I took last backup of log file around
10:15
> > and my database has crashed at 11:00, Is there any way how can I get the
> dml
> > records which incured in between 10:15 to 11:00., If yes then how ?
> >
> > Thanks
> > NOOR
> >
> > "Hari" <hari_prasad_k@hotmail.com> wrote in message
> > news:eM83nl6GEHA.2084@TK2MSFTNGP10.phx.gbl...
> > > Hi Noor,
> > >
> > > POINT-IN-TIME means recover database to a specific point of time.
> > >
> > > Say you have a Finance database, You have transaction log backup till
10
> > AM.
> > >
> > > At 10:15 AM, an user did a wrong updates, instead of putting 10%
> discount
> > he
> > > made 15% and did the processing and records got commited. In this case
> if
> > > you have a FULL recovery model set to that database you can recover
till
> > > 10:14 AM.
> > >
> > > Steps:
> > >
> > > 1. Perform a Transaction log backup at 10:15 AM on your real database.
> > > 2. Restore the full database backup to a new database with norecovery
> > > 3. Restore the subsequent transaction log backups (in the order of
> backup
> > > taken)with NORECOVERY till the backup taken in step1
> > > 4. Restore the last transaction log backup (taken in step.1 with
> RECOVERY
> > > and STOPAT option with date and time (Say in yor case 10:14 AM).
> > >
> > > Now you have got a new database with data till 10:14 AM.
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > >
> > >
> > > "Noorali Issani" <naissani@softhome.net> wrote in message
> > > news:O251BZ6GEHA.2392@tk2msftngp13.phx.gbl...
> > > > Hari, can you tell me about
> > > >
> > > > "This will help you to recover the datase
> > > > till POINT-IN-TIME in the event of crash."
> > > >
> > > > How ? like let's assume I took the log file back before 2 hours and
my
> > > > database gone crashed, how can I do POINT-IN-TIME recovery.
> > > >
> > > > Thanks in advance Hari
> > > > Noor
> > > >
> > > >
> > > > "Hari" <hari_prasad_k@hotmail.com> wrote in message
> > > > news:O0F5aU5GEHA.2840@TK2MSFTNGP10.phx.gbl...
> > > > > Hi Frank,
> > > > >
> > > > > If your data is not that critical and the database size is not
that
> > hge
> > > > > (less than 2 GB) you can perfom a FULL database backup daily once.
> > > > > If the data is ver critical set the database to "FULL" recovery
> model
> > > and
> > > > > perform a Transaction log backup. This will help you to recover
the
> > > datase
> > > > > till POINT-IN-TIME in the event of crash.
> > > > >
> > > > > For more information check Recovery models in books online.
> > > > >
> > > > > Thanks
> > > > > Hari
> > > > > MCDBA
> > > > >
> > > > > "frank" <anonymous@discussions.microsoft.com> wrote in message
> > > > > news:FE632019-4F4A-413D-8EEC-AE856AEC9760@microsoft.com...
> > > > > > in work , I usually use full backup .
> > > > > > i think file backup will be more useful ,but the information of
> it
> > is
> > > > > rare .
> > > > > > if anyone use it before .
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>