How can I change database status from loading

When I started restore, I used leave non operational. But later I find out
that I do not need to apply any additional files. I want to make it
operational. I am using SQL 7.
Any idea how can I change this status ? Thank you very much for reply.Try running the following:
RESTORE DATABASE YourDatabaseName
WITH RECOVERY
If it does not work try the last log backup filename and location.
RESTORE DATABASE YourDatabaseName
FROM DISK = 'c:\bkup.bak'
WITH RECOVERY
I do not have SQL 7 around but it works on 2000
Hope it will do the trick
Andre
"Astros" wrote:

> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.|||In Query Analyzer, you can run
RESTORE [mydatabase] WITH RECOVERY
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.|||Forgot the word DATABASE...
RESTORE DATABASE [mydatabase] WITH RECOVERY
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eUafDry$EHA.600@.TK2MSFTNGP09.phx.gbl...
> In Query Analyzer, you can run
> RESTORE [mydatabase] WITH RECOVERY
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
>