DROP a Mirrored DB

I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
a point where I want to delete the mirrored test database. However,
when I try to drop the DB on the mirrored server I receive an error.
It won't let me delete the DB since it is in "In Recovery" mode. What
do I have to do to DROP this database? The copy on the primary server
is already removed?
Msg 3743, Level 16, State 1, Line 1
Database Mirror_Test is enabled for Database Mirroring, Database
Mirroring must be removed before dropping the database.
Found out how.
ALTER DATABASE Mirror_Test SET PARTNER OFF
shaun.steckley@.gmail.com wrote:
> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
> --
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
> --
|||Hi Shaun
Check out http://msdn2.microsoft.com/en-us/library/ms180801.aspx for
instructions or look in Books Online.
John
"shaun.steckley@.gmail.com" wrote:

> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
> --
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
> --
>

DROP a Mirrored DB

I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
a point where I want to delete the mirrored test database. However,
when I try to drop the DB on the mirrored server I receive an error.
It won't let me delete the DB since it is in "In Recovery" mode. What
do I have to do to DROP this database? The copy on the primary server
is already removed?
Msg 3743, Level 16, State 1, Line 1
Database Mirror_Test is enabled for Database Mirroring, Database
Mirroring must be removed before dropping the database.Found out how.
ALTER DATABASE Mirror_Test SET PARTNER OFF
shaun.steckley@.gmail.com wrote:
> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
> --
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
> --|||Hi Shaun
Check out http://msdn2.microsoft.com/en-us/library/ms180801.aspx for
instructions or look in Books Online.
John
"shaun.steckley@.gmail.com" wrote:

> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
> --
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
> --
>

DROP a Mirrored DB

I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
a point where I want to delete the mirrored test database. However,
when I try to drop the DB on the mirrored server I receive an error.
It won't let me delete the DB since it is in "In Recovery" mode. What
do I have to do to DROP this database? The copy on the primary server
is already removed?
--
Msg 3743, Level 16, State 1, Line 1
Database Mirror_Test is enabled for Database Mirroring, Database
Mirroring must be removed before dropping the database.
--Found out how.
ALTER DATABASE Mirror_Test SET PARTNER OFF
shaun.steckley@.gmail.com wrote:
> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
> --
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
> --|||Hi Shaun
Check out http://msdn2.microsoft.com/en-us/library/ms180801.aspx for
instructions or look in Books Online.
John
"shaun.steckley@.gmail.com" wrote:
> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
> --
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
> --
>

Drill through in Olap Cube and implement at Share Point

Hi,

I want to integrate a Olap cube to sharepoint in which we can achieve drill through and multilingual also.

Please help me out to get solution of 2 problems.

Thanks

For the OLAP cube drillthrough from SharePoint, I'm using 3rd-party OLAP Web Parts, which expose cube-defined Reporting Actions. When the user selects such an action, a Reporting Services report is launched, which executes the MDX drillthrough query (using the OLE DB for OLAP Provider) and displays tabular results. Relevant current cube co-ordinates for the drillhrough are passed as URL paramters to the report.|||Deepak,

Which 3rd party tools which expose cube actions have you had the best luck with?

Thanks,
Todd
|||

Hi Todd,

I'm using DSP Portal Edition 4.3 right now, but perhaps ProClarity for SharePoint Portal Server will also work...

Drill through in Olap Cube and implement at Share Point

Hi,

I want to integrate a Olap cube to sharepoint in which we can achieve drill through and multilingual also.

Please help me out to get solution of 2 problems.

Thanks

For the OLAP cube drillthrough from SharePoint, I'm using 3rd-party OLAP Web Parts, which expose cube-defined Reporting Actions. When the user selects such an action, a Reporting Services report is launched, which executes the MDX drillthrough query (using the OLE DB for OLAP Provider) and displays tabular results. Relevant current cube co-ordinates for the drillhrough are passed as URL paramters to the report.|||Deepak,

Which 3rd party tools which expose cube actions have you had the best luck with?

Thanks,
Todd
|||

Hi Todd,

I'm using DSP Portal Edition 4.3 right now, but perhaps ProClarity for SharePoint Portal Server will also work...