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.
>|||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...
> 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...
>> > 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.
>> >
>> >
>>|||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
> 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...
> > > 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...
> > >> > 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.
> > >> >
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >|||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...
> 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...
> > > 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...
> > >> > 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...
> > 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.
> >
> >
>
>|||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...
> > 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...
> >> > 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.
> >> >
> >> >
> >>
> >>
> >>
>
>