Tuesday, February 21, 2012

Restore

Hi:
I am having a problem with restoring a databaase. My databse is around 7
GB. I am restoring it from last night backup as a different database name
using enterprise manager. After it restores successfully, it displays the
database in enterprise manager with loading status, i.e.,
MyDatabaseName(Loading). It stays in that status and does not refresh the
objects in it. I have tried this other smaller databases and it works fine.
I do not know why it is not working for this database.
Thanks for your help.
Did you specify what state you should leave the database in upon completion.
If you specified "NORECOVERY" it will be in loading status thinking one of
more transaction logs need to be restored.
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Sohail" <Sohail@.discussions.microsoft.com> wrote in message
news:BDA84046-C42C-4BE8-843A-2A0EEE2FE4A3@.microsoft.com...
> Hi:
> I am having a problem with restoring a databaase. My databse is around 7
> GB. I am restoring it from last night backup as a different database name
> using enterprise manager. After it restores successfully, it displays the
> database in enterprise manager with loading status, i.e.,
> MyDatabaseName(Loading). It stays in that status and does not refresh the
> objects in it. I have tried this other smaller databases and it works
fine.
> I do not know why it is not working for this database.
> Thanks for your help.
>
|||Thanks for quick reply. No, I did not specify "NoRecovery". Actually I am
using enterprise manager to restore. The default option is "Leave database
operational. No additional logs can be restored.". So It should not be
expecting any transactional logs. Any more suggestion would be helpful.
Thanks
"Gregory A. Larsen" wrote:

> Did you specify what state you should leave the database in upon completion.
> If you specified "NORECOVERY" it will be in loading status thinking one of
> more transaction logs need to be restored.
> --
> ----
> ----
> -
> Need SQL Server Examples check out my website
> http://www.geocities.com/sqlserverexamples
>
> "Sohail" <Sohail@.discussions.microsoft.com> wrote in message
> news:BDA84046-C42C-4BE8-843A-2A0EEE2FE4A3@.microsoft.com...
> fine.
>
>
|||Isn't is only a refresh thing in EM. Dud you try to exit EM and start it again?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sohail" <Sohail@.discussions.microsoft.com> wrote in message
news:31D65A60-500C-43C0-8A3A-5E41D0144E3F@.microsoft.com...[vbcol=seagreen]
> Thanks for quick reply. No, I did not specify "NoRecovery". Actually I am
> using enterprise manager to restore. The default option is "Leave database
> operational. No additional logs can be restored.". So It should not be
> expecting any transactional logs. Any more suggestion would be helpful.
> Thanks
> "Gregory A. Larsen" wrote:
|||No. It is not the refresh thing in EM. According to some documentation, I
also tried Restore Database DatabaseName with Recovery. This should activate
the database if waiting for transaction log to be applied but it gives an
error message that databse is partially restored. I do not know what's
happening. I did not happen with smaller databases. My database size is
about 7 or 8 GB. It should be able to handle that without any problem.
Anyway I end up doing detach/copy/attach to restore the database.
I am curious to know what is going on here.
Thanks for your reply.
"Tibor Karaszi" wrote:

> Isn't is only a refresh thing in EM. Dud you try to exit EM and start it again?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sohail" <Sohail@.discussions.microsoft.com> wrote in message
> news:31D65A60-500C-43C0-8A3A-5E41D0144E3F@.microsoft.com...
>
>
|||Have you tried "RESTORE VERIFYONLY" to verify you actually have a good
backup?
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Sohail" <Sohail@.discussions.microsoft.com> wrote in message
news:1A08C755-6828-4409-A789-C43164FAB21F@.microsoft.com...
> No. It is not the refresh thing in EM. According to some documentation,
I
> also tried Restore Database DatabaseName with Recovery. This should
activate[vbcol=seagreen]
> the database if waiting for transaction log to be applied but it gives an
> error message that databse is partially restored. I do not know what's
> happening. I did not happen with smaller databases. My database size is
> about 7 or 8 GB. It should be able to handle that without any problem.
> Anyway I end up doing detach/copy/attach to restore the database.
> I am curious to know what is going on here.
> Thanks for your reply.
> "Tibor Karaszi" wrote:
again?[vbcol=seagreen]
I am[vbcol=seagreen]
database[vbcol=seagreen]
be[vbcol=seagreen]
helpful.[vbcol=seagreen]
completion.[vbcol=seagreen]
one of[vbcol=seagreen]
--[vbcol=seagreen]
--[vbcol=seagreen]
around 7[vbcol=seagreen]
database name[vbcol=seagreen]
displays the[vbcol=seagreen]
refresh the[vbcol=seagreen]
works[vbcol=seagreen]
|||I suggest you do (all) the RESTORE from QA and post the RESTORE commands you execute...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sohail" <Sohail@.discussions.microsoft.com> wrote in message
news:1A08C755-6828-4409-A789-C43164FAB21F@.microsoft.com...[vbcol=seagreen]
> No. It is not the refresh thing in EM. According to some documentation, I
> also tried Restore Database DatabaseName with Recovery. This should activate
> the database if waiting for transaction log to be applied but it gives an
> error message that databse is partially restored. I do not know what's
> happening. I did not happen with smaller databases. My database size is
> about 7 or 8 GB. It should be able to handle that without any problem.
> Anyway I end up doing detach/copy/attach to restore the database.
> I am curious to know what is going on here.
> Thanks for your reply.
> "Tibor Karaszi" wrote:

No comments:

Post a Comment