"Lina" <L***@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?

"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" <L***@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?
>
>

"Lina" <L***@discussions.microsoft.com> wrote in message
news:F9EAECB4-269A-4F20-AC9A-6810FC9F5F7D@microsoft.com...
> 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" <L***@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?
>>
>>

"Tibor Karaszi" wrote:

> Yes
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Lina" <L***@discussions.microsoft.com> wrote in message
> news:F9EAECB4-269A-4F20-AC9A-6810FC9F5F7D@microsoft.com...
> > 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" <L***@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?
> >>
> >>
>
>

"Lina" <L***@discussions.microsoft.com> wrote in message
news:D2939914-B7CF-4C7E-8D84-A5BF7FD73998@microsoft.com...
> 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" <L***@discussions.microsoft.com> wrote in message
>> news:F9EAECB4-269A-4F20-AC9A-6810FC9F5F7D@microsoft.com...
>> > 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" <L***@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?
>> >>
>> >>
>>
>>

>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

"JXStern" <JXSternChange***@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%20Server\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
>