Tuesday, February 21, 2012

Restore / Backup - NEED HELP ASAP

Hi there,
I have a big favour to ask you.
I accidently delete one of my table in database. However, luckly I
have a bak file.
But, I can't restore whole database with bak file because since I
deleted table, there are new data in that table and other table as
well.
Is there any way I can only restore/update my database with bak file?
I know that there is no way to restore only one table. So, I am
looking for anther way to restore database.
Need your help as soon as possible.
ThanksYou can restore the backup to a different database name and different file
names and then recover the missing data. For example:
RESTORE DATABASE MyDatabase_Temp
FROM DISK='C:\Backups\MyDatabase.bak'
WITH
MOVE 'MyDatabase' TO 'D:\DataFiles\MyDatabase_Temp.mdf',
MOVE 'MyDatabase_Log' TO 'E:\LogFiles\MyDatabase_Temp_Log.ldf',
STATS=5
Also, you can list the logical file names needed for the MOVE option with
RESTORE FILELISTONLY:
RESTORE FILELISTONLY
FROM DISK='C:\Backups\MyDatabase.bak'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"portCo" <woosubc@.gmail.com> wrote in message
news:1174448208.379362.17330@.l77g2000hsb.googlegroups.com...
> Hi there,
> I have a big favour to ask you.
> I accidently delete one of my table in database. However, luckly I
> have a bak file.
> But, I can't restore whole database with bak file because since I
> deleted table, there are new data in that table and other table as
> well.
> Is there any way I can only restore/update my database with bak file?
> I know that there is no way to restore only one table. So, I am
> looking for anther way to restore database.
>
> Need your help as soon as possible.
>
> Thanks
>|||Thanks for your help. It really helped.
I actually restore to different name. However, I am having problem
with recovering missing data.
For example,
Schema is like (userID, userName, Phone)
table1 (1, A, 1111111111)
(2, B, 2222222222)
total: 2 rows.
table2 (2, B, 4444444444)
(3, C, 3333333333)
total: 2 rows.
So, here is a situation. I want to use table2 to update (if userID
exists) and insert (if userID not exists) of table 1.
I am trying to figure it out what I have to do for hours. But no luck
so far,
If anyone can help me out this, I will appreciated it.
Thanks alot,
On Mar 20, 8:52 pm, "Dan Guzman" <guzma...@.nospam-
online.sbcglobal.net> wrote:
> You can restore the backup to a different database name and different file
> names and then recover the missing data. For example:
> RESTORE DATABASE MyDatabase_Temp
> FROM DISK='C:\Backups\MyDatabase.bak'
> WITH
> MOVE 'MyDatabase' TO 'D:\DataFiles\MyDatabase_Temp.mdf',
> MOVE 'MyDatabase_Log' TO 'E:\LogFiles\MyDatabase_Temp_Log.ldf',
> STATS=5
> Also, you can list the logical file names needed for the MOVE option with
> RESTORE FILELISTONLY:
> RESTORE FILELISTONLY
> FROM DISK='C:\Backups\MyDatabase.bak'
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "portCo" <woos...@.gmail.com> wrote in message
> news:1174448208.379362.17330@.l77g2000hsb.googlegroups.com...
>
> > Hi there,
> > I have a big favour to ask you.
> > I accidently delete one of my table in database. However, luckly I
> > have a bak file.
> > But, I can't restore whole database with bak file because since I
> > deleted table, there are new data in that table and other table as
> > well.
> > Is there any way I can only restore/update my database with bak file?
> > I know that there is no way to restore only one table. So, I am
> > looking for anther way to restore database.
> > Need your help as soon as possible.
> > Thanks- Hide quoted text -
> - Show quoted text -|||Oops, I got it to work.
Thanks
On Mar 20, 10:38 pm, "portCo" <woos...@.gmail.com> wrote:
> Thanks for your help. It really helped.
> I actually restore to different name. However, I am having problem
> with recovering missing data.
> For example,
> Schema is like (userID, userName, Phone)
> table1 (1, A, 1111111111)
> (2, B, 2222222222)
> total: 2 rows.
> table2 (2, B, 4444444444)
> (3, C, 3333333333)
> total: 2 rows.
> So, here is a situation. I want to use table2 to update (if userID
> exists) and insert (if userID not exists) of table 1.
> I am trying to figure it out what I have to do for hours. But no luck
> so far,
> If anyone can help me out this, I will appreciated it.
> Thanks alot,
> On Mar 20, 8:52 pm, "Dan Guzman" <guzma...@.nospam-
>
> online.sbcglobal.net> wrote:
> > You can restore the backup to a different database name and different file
> > names and then recover the missing data. For example:
> > RESTORE DATABASE MyDatabase_Temp
> > FROM DISK='C:\Backups\MyDatabase.bak'
> > WITH
> > MOVE 'MyDatabase' TO 'D:\DataFiles\MyDatabase_Temp.mdf',
> > MOVE 'MyDatabase_Log' TO 'E:\LogFiles\MyDatabase_Temp_Log.ldf',
> > STATS=5
> > Also, you can list the logical file names needed for the MOVE option with
> > RESTORE FILELISTONLY:
> > RESTORE FILELISTONLY
> > FROM DISK='C:\Backups\MyDatabase.bak'
> > --
> > Hope this helps.
> > Dan Guzman
> > SQL Server MVP
> > "portCo" <woos...@.gmail.com> wrote in message
> >news:1174448208.379362.17330@.l77g2000hsb.googlegroups.com...
> > > Hi there,
> > > I have a big favour to ask you.
> > > I accidently delete one of my table in database. However, luckly I
> > > have a bak file.
> > > But, I can't restore whole database with bak file because since I
> > > deleted table, there are new data in that table and other table as
> > > well.
> > > Is there any way I can only restore/update my database with bak file?
> > > I know that there is no way to restore only one table. So, I am
> > > looking for anther way to restore database.
> > > Need your help as soon as possible.
> > > Thanks- Hide quoted text -
> > - Show quoted text -- Hide quoted text -
> - Show quoted text -|||I'm glad you were able to sort things out.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"portCo" <woosubc@.gmail.com> wrote in message
news:1174458361.130223.256700@.e65g2000hsc.googlegroups.com...
> Oops, I got it to work.
> Thanks
>
> On Mar 20, 10:38 pm, "portCo" <woos...@.gmail.com> wrote:
>> Thanks for your help. It really helped.
>> I actually restore to different name. However, I am having problem
>> with recovering missing data.
>> For example,
>> Schema is like (userID, userName, Phone)
>> table1 (1, A, 1111111111)
>> (2, B, 2222222222)
>> total: 2 rows.
>> table2 (2, B, 4444444444)
>> (3, C, 3333333333)
>> total: 2 rows.
>> So, here is a situation. I want to use table2 to update (if userID
>> exists) and insert (if userID not exists) of table 1.
>> I am trying to figure it out what I have to do for hours. But no luck
>> so far,
>> If anyone can help me out this, I will appreciated it.
>> Thanks alot,
>> On Mar 20, 8:52 pm, "Dan Guzman" <guzma...@.nospam-
>>
>> online.sbcglobal.net> wrote:
>> > You can restore the backup to a different database name and different
>> > file
>> > names and then recover the missing data. For example:
>> > RESTORE DATABASE MyDatabase_Temp
>> > FROM DISK='C:\Backups\MyDatabase.bak'
>> > WITH
>> > MOVE 'MyDatabase' TO 'D:\DataFiles\MyDatabase_Temp.mdf',
>> > MOVE 'MyDatabase_Log' TO 'E:\LogFiles\MyDatabase_Temp_Log.ldf',
>> > STATS=5
>> > Also, you can list the logical file names needed for the MOVE option
>> > with
>> > RESTORE FILELISTONLY:
>> > RESTORE FILELISTONLY
>> > FROM DISK='C:\Backups\MyDatabase.bak'
>> > --
>> > Hope this helps.
>> > Dan Guzman
>> > SQL Server MVP
>> > "portCo" <woos...@.gmail.com> wrote in message
>> >news:1174448208.379362.17330@.l77g2000hsb.googlegroups.com...
>> > > Hi there,
>> > > I have a big favour to ask you.
>> > > I accidently delete one of my table in database. However, luckly I
>> > > have a bak file.
>> > > But, I can't restore whole database with bak file because since I
>> > > deleted table, there are new data in that table and other table as
>> > > well.
>> > > Is there any way I can only restore/update my database with bak file?
>> > > I know that there is no way to restore only one table. So, I am
>> > > looking for anther way to restore database.
>> > > Need your help as soon as possible.
>> > > Thanks- Hide quoted text -
>> > - Show quoted text -- Hide quoted text -
>> - Show quoted text -
>

No comments:

Post a Comment