Database loading..

Hello,
We did a restore of a database to a test database, however after the restore
the database is still showing as loading. I was not present during the
restore but it looks like the norecovery option was not used. We tried the
database restore dbname recovery option but that did not work. We also tried
rebooting and restarting the services. Any suggestions?
Is it just a refresh issue in the GUI? If no, did you receive an error from the:
RESTORE DATABASE dbname WITH RECOVERY
What was the exact error message, if any was returned.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lina" <Lina@.discussions.microsoft.com> wrote in message
news:51ACE18B-F4B4-4ED2-A899-3BCE829D327B@.microsoft.com...
> Hello,
> We did a restore of a database to a test database, however after the restore
> the database is still showing as loading. I was not present during the
> restore but it looks like the norecovery option was not used. We tried the
> database restore dbname recovery option but that did not work. We also tried
> rebooting and restarting the services. Any suggestions?
|||Do you mean the error message in SQL Query Analyzer after the restore
database dbname recovery?
"Tibor Karaszi" wrote:

> Is it just a refresh issue in the GUI? If no, did you receive an error from the:
> RESTORE DATABASE dbname WITH RECOVERY
> What was the exact error message, if any was returned.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Lina" <Lina@.discussions.microsoft.com> wrote in message
> news:51ACE18B-F4B4-4ED2-A899-3BCE829D327B@.microsoft.com...
>
|||Yes
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lina" <Lina@.discussions.microsoft.com> wrote in message
news:F9EAECB4-269A-4F20-AC9A-6810FC9F5F7D@.microsoft.com...[vbcol=seagreen]
> Do you mean the error message in SQL Query Analyzer after the restore
> database dbname recovery?
> "Tibor Karaszi" wrote:
|||We get error 4331.
"Tibor Karaszi" wrote:

> Yes
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Lina" <Lina@.discussions.microsoft.com> wrote in message
> news:F9EAECB4-269A-4F20-AC9A-6810FC9F5F7D@.microsoft.com...
>
|||Hi Lina
Even though some of us have been using SQL Server for many years, most of us
don't memorize error numbers. After 19 years, I know 1205 and 208.
It would be helpful if you could also let us know the text of the error
message.
Also, can you show us the exact command used?
The more info you can provide about exactly what steps you took and what the
results/response was, the more help we can provide.
Thanks
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Lina" <Lina@.discussions.microsoft.com> wrote in message
news:D2939914-B7CF-4C7E-8D84-A5BF7FD73998@.microsoft.com...[vbcol=seagreen]
> We get error 4331.
> "Tibor Karaszi" wrote:
|||BOL sez:
4331 16 The database cannot be recovered because the files have been
restored to inconsistent points in time.
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\trblsql.chm::/tr_syserrors1a_81o9.htm
J.
On Fri, 29 Sep 2006 13:56:57 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:

>Hi Lina
>Even though some of us have been using SQL Server for many years, most of us
>don't memorize error numbers. After 19 years, I know 1205 and 208.
>It would be helpful if you could also let us know the text of the error
>message.
>Also, can you show us the exact command used?
>The more info you can provide about exactly what steps you took and what the
>results/response was, the more help we can provide.
>Thanks
|||That is a new one to me. I guess Lina is best served by re-doing the restore or opening a ticket
with MS Support if the problem persists.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:jblrh21bd2vrf50ioill727cnsu4v8308g@.4ax.com...
> BOL sez:
> 4331 16 The database cannot be recovered because the files have been
> restored to inconsistent points in time.
> mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\trblsql.chm::/tr_syserrors1a_81o9.htm
> J.
>
> On Fri, 29 Sep 2006 13:56:57 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
>