Info on Restore

I made wrong changes to my DB just today.
I wish to return back to the previous state.
Full Backup run daily in the night and nop Transaction Log backups
were made.
Can i backup now the actual Transaction Log and next restore it at a
particular time ?
many thanks
On 18 Feb, 13:23, Zarko Jovanovic
<mind_lessIsHsAsTsEsSsPsA...@.inet.hr> wrote:
> BOBO wrote:
>
>
> backup log, restore full, restore log stopat
> look in BOL for details
Hi,
Thanks to all.
Do you mean I have to restore the full Transaction log and next the
Transaction log with the StopAt? Why I need to restore the full TL
first?
|||I believe Zarko means for you to restore your last full database backup, and
then restore the log backup to the time you wish.
Check the BOL for detailed instructions on using "stopat".
"BOBO" wrote:

> On 18 Feb, 13:23, Zarko Jovanovic
> <mind_lessIsHsAsTsEsSsPsA...@.inet.hr> wrote:
> Hi,
> Thanks to all.
> Do you mean I have to restore the full Transaction log and next the
> Transaction log with the StopAt? Why I need to restore the full TL
> first?
>
|||Hi,
look here:
http://technet.microsoft.com/en-us/library/ms179451.aspx
this is good example for you
regards

Info on Restore

I made wrong changes to my DB just today.
I wish to return back to the previous state.
Full Backup run daily in the night and nop Transaction Log backups
were made.
Can i backup now the actual Transaction Log and next restore it at a
particular time ?
many thanksBOBO wrote:
> I made wrong changes to my DB just today.
> I wish to return back to the previous state.
> Full Backup run daily in the night and nop Transaction Log backups
> were made.
> Can i backup now the actual Transaction Log and next restore it at a
> particular time ?
>
> many thanks
yes|||BOBO wrote:
> I made wrong changes to my DB just today.
> I wish to return back to the previous state.
> Full Backup run daily in the night and nop Transaction Log backups
> were made.
> Can i backup now the actual Transaction Log and next restore it at a
> particular time ?
>
> many thanks
backup log, restore full, restore log stopat
look in BOL for details|||On 18 Feb, 13:23, Zarko Jovanovic
<mind_lessIsHsAsTsEsSsPsA...@.inet.hr> wrote:
> BOBO wrote:
> > I made wrong changes to my DB just today.
> > I wish to return back to the previous state.
> > Full Backup run daily in the night and nop Transaction Log backups
> > were made.
> > Can i backup now =A0the actual Transaction Log and next restore it at a
> > particular time ?
> > many thanks
> backup log, restore full, restore log stopat
> look in BOL for details
Hi,
Thanks to all.
Do you mean I have to restore the full Transaction log and next the
Transaction log with the StopAt? Why I need to restore the full TL
first?|||I believe Zarko means for you to restore your last full database backup, and
then restore the log backup to the time you wish.
Check the BOL for detailed instructions on using "stopat".
"BOBO" wrote:
> On 18 Feb, 13:23, Zarko Jovanovic
> <mind_lessIsHsAsTsEsSsPsA...@.inet.hr> wrote:
> > BOBO wrote:
> > > I made wrong changes to my DB just today.
> >
> > > I wish to return back to the previous state.
> >
> > > Full Backup run daily in the night and nop Transaction Log backups
> > > were made.
> >
> > > Can i backup now the actual Transaction Log and next restore it at a
> > > particular time ?
> >
> > > many thanks
> >
> > backup log, restore full, restore log stopat
> > look in BOL for details
> Hi,
> Thanks to all.
> Do you mean I have to restore the full Transaction log and next the
> Transaction log with the StopAt? Why I need to restore the full TL
> first?
>|||Hi,
look here:
http://technet.microsoft.com/en-us/library/ms179451.aspx
this is good example for you
--
regards

Inflectional ?

Hi,
Ok, say I want to pull back all '"picture ~ frame"' and '"pictures ~
frames"' so I do the following; FormsOf(Inflectional, "picture ~ frame")
this results in syntax error. I thought inflectional would automatically do
it if I put " around the near words. The first ones I listed do not pull
back the plurals, if I use the wildcard I get what I need but wonder if this
is the way it should work say I also want framing so I do fram* but this
would also give me frampton which I do not want. Do I need to use the
thesuraus or is there some way of forming the inflectional that I am not
getting?
Thanks,
jc
Sorry forgot, sql 2k5 sp2a
jc
|||A freetext query will do an implicit near and the stemming you are looking
for.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John Cantley" <johnca@.magenic.com> wrote in message
news:OoTJLiBcHHA.208@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Ok, say I want to pull back all '"picture ~ frame"' and '"pictures ~
> frames"' so I do the following; FormsOf(Inflectional, "picture ~ frame")
> this results in syntax error. I thought inflectional would automatically
> do it if I put " around the near words. The first ones I listed do not
> pull back the plurals, if I use the wildcard I get what I need but wonder
> if this is the way it should work say I also want framing so I do fram*
> but this would also give me frampton which I do not want. Do I need to use
> the thesuraus or is there some way of forming the inflectional that I am
> not getting?
> Thanks,
> jc
>
sql