|
Home > Archive > MS SQL Server > October 2006 > Database loading..
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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?
| |
| Tibor Karaszi 2006-10-24, 6:33 pm |
| 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@microso
ft.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@microso
ft.com...
>
>
| |
| Tibor Karaszi 2006-10-24, 6:33 pm |
| 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@microso
ft.com...[color=darkred]
> Do you mean the error message in SQL Query Analyzer after the restore
> database dbname recovery?
>
> "Tibor Karaszi" wrote:
>
| |
|
|
| Kalen Delaney 2006-10-24, 6:33 pm |
| 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@microso
ft.com...[color=darkred]
> We get error 4331.
>
> "Tibor Karaszi" wrote:
>
| |
| JXStern 2006-10-24, 6:33 pm |
| BOL sez:
4331 16 The database cannot be recovered because the files have been
restored to inconsistent points in time.
mk:@MSITStore:C:\Pro
gram%20Files\Microso
ft%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_newsg
roups.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
| |
| Tibor Karaszi 2006-10-24, 6:33 pm |
| 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:jblrh21bd2vrf50
ioill727cnsu4v8308g@
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:\Pro
gram%20Files\Microso
ft%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_newsg
roups.com> wrote:
>
>
|
|
|
|
|