Showing posts with label operational. Show all posts
Showing posts with label operational. Show all posts

Wednesday, March 7, 2012

Operational but able to restore additional transaction logs

I have databases which have been left in the operational, but able to restore
additional transaction logs mode. I had done this last week thinking I could
easily setup log shipping that day. Tonight's backup will be the first full
backup corresponding with transaction log backups. The full backup will need
to run against this database which currently shows (loading) as its state.
Should this be removed or fixed somehow - at this point, I cannot delete, or
restore, or anything else including go to the properties to reset the state
because the database is not in the databases collection for this server...
so, what do I do now?
Regards,
Jamie
Wow, I figured that one out. I checked the sysdatabases as I had tried to
detach the database that was indicated as loading. Detaching removes it
from the sysdatabases. I only needed to refresh the Enterprise Manager.
Regards,
Jamie
"thejamie" wrote:

> I have databases which have been left in the operational, but able to restore
> additional transaction logs mode. I had done this last week thinking I could
> easily setup log shipping that day. Tonight's backup will be the first full
> backup corresponding with transaction log backups. The full backup will need
> to run against this database which currently shows (loading) as its state.
> Should this be removed or fixed somehow - at this point, I cannot delete, or
> restore, or anything else including go to the properties to reset the state
> because the database is not in the databases collection for this server...
> so, what do I do now?
> --
> Regards,
> Jamie

Operational and Analytical CRM??

Hi,
While going through an article I came across the subject terms and
wanted to ask the experts if these are "basically" the same thing as
"BI" or are these totally different?
I'll appreciate any pointers/help from anyone.
Thanks.
Dont' think they are the same. Here's my "guess"...
* CRM = Customer Relationsship Management - something about customers...but
in BI you can have lots of areas such as finance, sales, inventory and so
forth...
* however - i would guess that data mining could be relevant a lot in CRM on
websites and for that i would think an AS engine could be used
* In CRM there a many more processes related to customers - that could be
the operatonal CRM above and perhaps the analytical could be solved by
BI...?
"Learner" <wantnospam@.email.com> skrev i en meddelelse
news:MPG.1b1714e36d0ad7aa989703@.msnews.microsoft.c om...
> Hi,
> While going through an article I came across the subject terms and
> wanted to ask the experts if these are "basically" the same thing as
> "BI" or are these totally different?
> I'll appreciate any pointers/help from anyone.
> --
> Thanks.

Operational and Analytical CRM??

Hi,
While going through an article I came across the subject terms and
wanted to ask the experts if these are "basically" the same thing as
"BI" or are these totally different?
I'll appreciate any pointers/help from anyone.
Thanks.Dont' think they are the same. Here's my "guess"...
* CRM = Customer Relationsship Management - something about customers...but
in BI you can have lots of areas such as finance, sales, inventory and so
forth...
* however - i would guess that data mining could be relevant a lot in CRM on
websites and for that i would think an AS engine could be used
* In CRM there a many more processes related to customers - that could be
the operatonal CRM above and perhaps the analytical could be solved by
BI...?
"Learner" <wantnospam@.email.com> skrev i en meddelelse
news:MPG.1b1714e36d0ad7aa989703@.msnews.microsoft.com...
> Hi,
> While going through an article I came across the subject terms and
> wanted to ask the experts if these are "basically" the same thing as
> "BI" or are these totally different?
> I'll appreciate any pointers/help from anyone.
> --
> Thanks.