restore nightmares

I wasn't paying attention and I started a restore on one of my dbs.
I stoped in the middle of it. I tried to reconnect to my db but I was
told that I couldn't. I restored a recent copy but lost all the data I
worked on today. Any chance I can restore it?Unfortunately not.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Won Lee" <noemail@.nospam.com> wrote in message
news:er9yAwiWEHA.716@.TK2MSFTNGP11.phx.gbl...
> I wasn't paying attention and I started a restore on one of my dbs.
> I stoped in the middle of it. I tried to reconnect to my db but I was
> told that I couldn't. I restored a recent copy but lost all the data I
> worked on today. Any chance I can restore it?
>|||Hi,
What type of recovery model you are using? If it is FULL or BULK_Logged you
can recover back the database
provided if you have taken Trasaction log backup.
1. Restore Yesterdays full backup with NORECOVERY
2. Restore the transaction logs one by one till the last with NORECOVERY
3. Restore the last transaction log with RECOVERY option.
This will recover the database till the last trasnaction log backup.
--
Thanks
Hari
MCDBA
"Won Lee" <noemail@.nospam.com> wrote in message
news:er9yAwiWEHA.716@.TK2MSFTNGP11.phx.gbl...
> I wasn't paying attention and I started a restore on one of my dbs.
> I stoped in the middle of it. I tried to reconnect to my db but I was
> told that I couldn't. I restored a recent copy but lost all the data I
> worked on today. Any chance I can restore it?
>|||I had changed it to simple because the transaction log was getting to
big during the day before I could shrinkfile it.
Is there a way to see when the last manual backup was made? I'm having
some problems looking for the backup.
Hari wrote:
> Hi,
> What type of recovery model you are using? If it is FULL or BULK_Logged you
> can recover back the database
> provided if you have taken Trasaction log backup.
> 1. Restore Yesterdays full backup with NORECOVERY
> 2. Restore the transaction logs one by one till the last with NORECOVERY
> 3. Restore the last transaction log with RECOVERY option.
> This will recover the database till the last trasnaction log backup.
> --
> Thanks
> Hari
> MCDBA
> "Won Lee" <noemail@.nospam.com> wrote in message
> news:er9yAwiWEHA.716@.TK2MSFTNGP11.phx.gbl...
>>I wasn't paying attention and I started a restore on one of my dbs.
>>I stoped in the middle of it. I tried to reconnect to my db but I was
>>told that I couldn't. I restored a recent copy but lost all the data I
>>worked on today. Any chance I can restore it?
>
>|||Hi,
The table BACKUPSET in MSDB contains the information of backup performed.
Use the below query to get the database name and backup date.
Since we are sorting in descenting order of backup_finish_date the latest
backup date will be displayed first.
select database_name,backup_finish_date from msdb..backupset
order by backup_finish_date desc
--
Thanks
Hari
MCDBA
"Won Lee" <noemail@.nospam.com> wrote in message
news:OLtJAxnWEHA.2940@.TK2MSFTNGP09.phx.gbl...
> I had changed it to simple because the transaction log was getting to
> big during the day before I could shrinkfile it.
> Is there a way to see when the last manual backup was made? I'm having
> some problems looking for the backup.
>
> Hari wrote:
> > Hi,
> >
> > What type of recovery model you are using? If it is FULL or BULK_Logged
you
> > can recover back the database
> > provided if you have taken Trasaction log backup.
> >
> > 1. Restore Yesterdays full backup with NORECOVERY
> > 2. Restore the transaction logs one by one till the last with NORECOVERY
> > 3. Restore the last transaction log with RECOVERY option.
> >
> > This will recover the database till the last trasnaction log backup.
> >
> > --
> > Thanks
> > Hari
> > MCDBA
> > "Won Lee" <noemail@.nospam.com> wrote in message
> > news:er9yAwiWEHA.716@.TK2MSFTNGP11.phx.gbl...
> >
> >>I wasn't paying attention and I started a restore on one of my dbs.
> >>I stoped in the middle of it. I tried to reconnect to my db but I was
> >>told that I couldn't. I restored a recent copy but lost all the data I
> >>worked on today. Any chance I can restore it?
> >>
> >
> >
> >
>