Database Recovery Problem

Greetings,
I am attempting to restore some databases to a SQL Server
2000 Installation that fell apart after loading SP4 for
Windows 2000. The backups were made using Veritas Backup
Exec 8.6. on a remote backup server. When I do a restore
on my databases Veritas restores all of them to the the
SQL Server and they appear in Enterprise Manager. However
the databases are in a state of loading and I cannot seem
to find a way to take them out of this loading state to
complete the restore to normal operation.
I am new to SQL Server so I am at a loss as to what to do
to rectify this situation.
Thanks in advance for the help.
Joe.If you have restored the databases with norecovery you can
restore database mydb with recovery
to bring it on-line.
If in fact veritas hasn't completed the restore then you
will have to go back to that product.
>"Joe Toth" <jtoth@.cmefcu.org> wrote in message
>news:029d01c34727$da60cee0$a401280a@.phx.gbl...
>> Greetings,
>> I am attempting to restore some databases to a SQL
Server
>> 2000 Installation that fell apart after loading SP4 for
>> Windows 2000. The backups were made using Veritas Backup
>> Exec 8.6. on a remote backup server. When I do a restore
>> on my databases Veritas restores all of them to the the
>> SQL Server and they appear in Enterprise Manager.
However
>> the databases are in a state of loading and I cannot
seem
>> to find a way to take them out of this loading state to
>> complete the restore to normal operation.
>> I am new to SQL Server so I am at a loss as to what to
do
>> to rectify this situation.
>> Thanks in advance for the help.
>> Joe.
>
>.
>|||It's been a few months since I restored from BE, but I
think it's an option when configuring the restore on the
SQL tab. The db is left in this state so you can apply
logs if you need to.
--Scott
>--Original Message--
>Greetings,
>I am attempting to restore some databases to a SQL Server
>2000 Installation that fell apart after loading SP4 for
>Windows 2000. The backups were made using Veritas Backup
>Exec 8.6. on a remote backup server. When I do a restore
>on my databases Veritas restores all of them to the the
>SQL Server and they appear in Enterprise Manager. However
>the databases are in a state of loading and I cannot seem
>to find a way to take them out of this loading state to
>complete the restore to normal operation.
>I am new to SQL Server so I am at a loss as to what to do
>to rectify this situation.
>Thanks in advance for the help.
>Joe.
>.
>