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]
>