Restore database

Good morning. I had previously backed up my SQL Databases to a ZIP Drive. I
have re-formatted my HD, re-installed SQL Server 2000, but my user defined
databases are not there of course. The backup files are on the ZIP drive and
I need to to Restore several of them to the SQL Server 2000. I have tried to
restore three of them but in Enterprise Manager it lists the three that I am
trying to restore but just to the right of each it shows (Loading/Suspect)
and when I click the plus sign it shows "No Items". Can someone help me
with this, please? If I can't get these three restored I will have to
re-create them again. Thanks in advance, Jim.
Jim Richards wrote:
> Good morning. I had previously backed up my SQL Databases to a ZIP Drive. I
> have re-formatted my HD, re-installed SQL Server 2000, but my user defined
> databases are not there of course. The backup files are on the ZIP drive and
> I need to to Restore several of them to the SQL Server 2000. I have tried to
> restore three of them but in Enterprise Manager it lists the three that I am
> trying to restore but just to the right of each it shows (Loading/Suspect)
> and when I click the plus sign it shows "No Items". Can someone help me
> with this, please? If I can't get these three restored I will have to
> re-create them again. Thanks in advance, Jim.
>
...maybe a stupid question, but have you tried to hif "Refresh"?
Regards
Steen
|||I had not tried it so I selected each of the three dbs one at a time and
then hit View->Refresh on each one of them. It didn't help a bit but I do
appreciate your suggestion. Jim.
"Steen Persson" <spe@.REMOVEdatea.dk> wrote in message
news:eM3cRIBJFHA.1308@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Jim Richards wrote:
Drive. I[vbcol=seagreen]
defined[vbcol=seagreen]
and[vbcol=seagreen]
tried to[vbcol=seagreen]
I am[vbcol=seagreen]
(Loading/Suspect)
> ...maybe a stupid question, but have you tried to hif "Refresh"?
> Regards
> Steen
|||Try to restore using Query Analyzer and the RESTORE DATABASE t-sql
statement. You should get an error, post it here so we can help you further.
-Argenis
"Jim Richards" <JWRichards@.satx.rr.com> wrote in message
news:_bmXd.52340$Qz1.32086@.fe2.texas.rr.com...
> Good morning. I had previously backed up my SQL Databases to a ZIP Drive.
I
> have re-formatted my HD, re-installed SQL Server 2000, but my user defined
> databases are not there of course. The backup files are on the ZIP drive
and
> I need to to Restore several of them to the SQL Server 2000. I have tried
to
> restore three of them but in Enterprise Manager it lists the three that I
am
> trying to restore but just to the right of each it shows (Loading/Suspect)
> and when I click the plus sign it shows "No Items". Can someone help me
> with this, please? If I can't get these three restored I will have to
> re-create them again. Thanks in advance, Jim.
>
|||Thank you, Argenis, so very much for your offer to help. I am just an
individual who is trying to learn how to use SQL Server 2000 at home. I do
not run a business from my home. I have never tried to Restore a database
before either by t-sql statements or the Enterprise Manager. I have "SAMS
Teach Yourself Microsoft SQL Server 2000 in 21 Days" (I have the Developers
Edition) and day 8 covers "Restoring Your Databases" but all the statements
syntax and examples cover restoring a database that you backed up from SQL
Server so the Backup Log is in the SQL Server. That is not the case in my
situation as I re-formatted the hard drive and reinstalled SQL Server 2000
so there are no Backup logs for the three databases that I am trying to
restore (Bindery - ROE - ROE6) which are shown in
http://www.jimwrichards.com/images/Restore2.gif . If I use this restore
statement: RESTORE DATABASE Bindery FILE = Bindery_Data FROM
F:\SQL_DB_BUs\Bindery2.BAK WITH NORECOVERY REPLACE
RESTORE LOG Bindery_Log FROM F:\SQL_DB_BUs\Bindery2.BAK WITH RECOVERY
REPLACE
will these statements restore the database "Bindery"? Thanks in advance for
your help. Jim.
"Argenis Fernandez" <argenis@.spam.sucks.gmail.com> wrote in message
news:ugnSJ9CJFHA.3832@.TK2MSFTNGP12.phx.gbl...
> Try to restore using Query Analyzer and the RESTORE DATABASE t-sql
> statement. You should get an error, post it here so we can help you
further.[vbcol=seagreen]
> -Argenis
> "Jim Richards" <JWRichards@.satx.rr.com> wrote in message
> news:_bmXd.52340$Qz1.32086@.fe2.texas.rr.com...
Drive.[vbcol=seagreen]
> I
defined[vbcol=seagreen]
> and
tried[vbcol=seagreen]
> to
I[vbcol=seagreen]
> am
(Loading/Suspect)
>
|||Argenis, I don't know if this graphic will help but it is what is shown in
Enterprise Manager when the Databases are expanded. Notice that the three
that I am trying to Restore all show the (Loading/Suspect) to the right of
the database name.
(http://www.jimwrichards.com/images/Restore3.gif
I sure do appreciate your help. Jim.
"Argenis Fernandez" <argenis@.spam.sucks.gmail.com> wrote in message
news:ugnSJ9CJFHA.3832@.TK2MSFTNGP12.phx.gbl...
> Try to restore using Query Analyzer and the RESTORE DATABASE t-sql
> statement. You should get an error, post it here so we can help you
further.[vbcol=seagreen]
> -Argenis
> "Jim Richards" <JWRichards@.satx.rr.com> wrote in message
> news:_bmXd.52340$Qz1.32086@.fe2.texas.rr.com...
Drive.[vbcol=seagreen]
> I
defined[vbcol=seagreen]
> and
tried[vbcol=seagreen]
> to
I[vbcol=seagreen]
> am
(Loading/Suspect)
>

Restore database

Good morning. I had previously backed up my SQL Databases to a ZIP Drive. I
have re-formatted my HD, re-installed SQL Server 2000, but my user defined
databases are not there of course. The backup files are on the ZIP drive and
I need to to Restore several of them to the SQL Server 2000. I have tried to
restore three of them but in Enterprise Manager it lists the three that I am
trying to restore but just to the right of each it shows (Loading/Suspect)
and when I click the plus sign it shows "No Items". Can someone help me
with this, please? If I can't get these three restored I will have to
re-create them again. Thanks in advance, Jim.Jim Richards wrote:
> Good morning. I had previously backed up my SQL Databases to a ZIP Drive.
I
> have re-formatted my HD, re-installed SQL Server 2000, but my user defined
> databases are not there of course. The backup files are on the ZIP drive a
nd
> I need to to Restore several of them to the SQL Server 2000. I have tried
to
> restore three of them but in Enterprise Manager it lists the three that I
am
> trying to restore but just to the right of each it shows (Loading/Suspect)
> and when I click the plus sign it shows "No Items". Can someone help me
> with this, please? If I can't get these three restored I will have to
> re-create them again. Thanks in advance, Jim.
>
...maybe a stupid question, but have you tried to hif "Refresh"?
Regards
Steen|||I had not tried it so I selected each of the three dbs one at a time and
then hit View->Refresh on each one of them. It didn't help a bit but I do
appreciate your suggestion. Jim.
"Steen Persson" <spe@.REMOVEdatea.dk> wrote in message
news:eM3cRIBJFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Jim Richards wrote:
Drive. I[vbcol=seagreen]
defined[vbcol=seagreen]
and[vbcol=seagreen]
tried to[vbcol=seagreen]
I am[vbcol=seagreen]
(Loading/Suspect)[vbcol=seagreen]
> ...maybe a stupid question, but have you tried to hif "Refresh"?
> Regards
> Steen|||Try to restore using Query Analyzer and the RESTORE DATABASE t-sql
statement. You should get an error, post it here so we can help you further.
-Argenis
"Jim Richards" <JWRichards@.satx.rr.com> wrote in message
news:_bmXd.52340$Qz1.32086@.fe2.texas.rr.com...
> Good morning. I had previously backed up my SQL Databases to a ZIP Drive.
I
> have re-formatted my HD, re-installed SQL Server 2000, but my user defined
> databases are not there of course. The backup files are on the ZIP drive
and
> I need to to Restore several of them to the SQL Server 2000. I have tried
to
> restore three of them but in Enterprise Manager it lists the three that I
am
> trying to restore but just to the right of each it shows (Loading/Suspect)
> and when I click the plus sign it shows "No Items". Can someone help me
> with this, please? If I can't get these three restored I will have to
> re-create them again. Thanks in advance, Jim.
>|||Thank you, Argenis, so very much for your offer to help. I am just an
individual who is trying to learn how to use SQL Server 2000 at home. I do
not run a business from my home. I have never tried to Restore a database
before either by t-sql statements or the Enterprise Manager. I have "SAMS
Teach Yourself Microsoft SQL Server 2000 in 21 Days" (I have the Developers
Edition) and day 8 covers "Restoring Your Databases" but all the statements
syntax and examples cover restoring a database that you backed up from SQL
Server so the Backup Log is in the SQL Server. That is not the case in my
situation as I re-formatted the hard drive and reinstalled SQL Server 2000
so there are no Backup logs for the three databases that I am trying to
restore (Bindery - ROE - ROE6) which are shown in
http://www.jimwrichards.com/images/Restore2.gif . If I use this restore
statement: RESTORE DATABASE Bindery FILE = Bindery_Data FROM
F:\SQL_DB_BUs\Bindery2.BAK WITH NORECOVERY REPLACE
RESTORE LOG Bindery_Log FROM F:\SQL_DB_BUs\Bindery2.BAK WITH RECOVERY
REPLACE
will these statements restore the database "Bindery"? Thanks in advance for
your help. Jim.
"Argenis Fernandez" <argenis@.spam.sucks.gmail.com> wrote in message
news:ugnSJ9CJFHA.3832@.TK2MSFTNGP12.phx.gbl...
> Try to restore using Query Analyzer and the RESTORE DATABASE t-sql
> statement. You should get an error, post it here so we can help you
further.
> -Argenis
> "Jim Richards" <JWRichards@.satx.rr.com> wrote in message
> news:_bmXd.52340$Qz1.32086@.fe2.texas.rr.com...
Drive.[vbcol=seagreen]
> I
defined[vbcol=seagreen]
> and
tried[vbcol=seagreen]
> to
I[vbcol=seagreen]
> am
(Loading/Suspect)[vbcol=seagreen]
>|||Argenis, I don't know if this graphic will help but it is what is shown in
Enterprise Manager when the Databases are expanded. Notice that the three
that I am trying to Restore all show the (Loading/Suspect) to the right of
the database name.
(http://www.jimwrichards.com/images/Restore3.gif
I sure do appreciate your help. Jim.
"Argenis Fernandez" <argenis@.spam.sucks.gmail.com> wrote in message
news:ugnSJ9CJFHA.3832@.TK2MSFTNGP12.phx.gbl...
> Try to restore using Query Analyzer and the RESTORE DATABASE t-sql
> statement. You should get an error, post it here so we can help you
further.
> -Argenis
> "Jim Richards" <JWRichards@.satx.rr.com> wrote in message
> news:_bmXd.52340$Qz1.32086@.fe2.texas.rr.com...
Drive.[vbcol=seagreen]
> I
defined[vbcol=seagreen]
> and
tried[vbcol=seagreen]
> to
I[vbcol=seagreen]
> am
(Loading/Suspect)[vbcol=seagreen]
>

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...
>
>
>
>
>
>
>
> - 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:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - 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:
>

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.
Thanks
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" <woosubc@.gmail.com> wrote in message
news:1174448208.379362.17330@.l77g2000hsb.googlegro ups.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.googlegro ups.com...
>
>
>
>
> - 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:
>
>
>
>
>
>
>
> - 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.googlegr oups.com...
> Oops, I got it to work.
> Thanks
>
> On Mar 20, 10:38 pm, "portCo" <woos...@.gmail.com> wrote:
>