Database Overwritten: asynchronous

Showing posts with label asynchronous. Show all posts

Sunday, March 25, 2012

database mirroring question

Is Asynchronous database mirroring support in the Standard Edition of
SQL 2005?
I've read some docs that say it isn't. However, my manager saids that
he was told it was (or would work), something about 'single stream'? I
have not been able to find any docs that talks about 'single stream'.
Can anyone advise or point me in the right direction?
thanks all,
JDJoeyD
If I remember well, database mirroring is supported only on Enterprise
Edition
"JoeyD" <joeydba@.gmail.com> wrote in message
news:1168635799.710707.324810@.51g2000cwl.googlegroups.com...
> Is Asynchronous database mirroring support in the Standard Edition of
> SQL 2005?
> I've read some docs that say it isn't. However, my manager saids that
> he was told it was (or would work), something about 'single stream'? I
> have not been able to find any docs that talks about 'single stream'.
> Can anyone advise or point me in the right direction?
> thanks all,
> JD
>|||Synchronous mirroring is supported on Standard and Enterprise editions.
Asynchronous mode is only supported on Enterprise edition.
--
Paul Randal
Principal Lead Program Manager
Core Storage Engine, Microsoft SQL Server Team
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uh6Amz7NHHA.3916@.TK2MSFTNGP02.phx.gbl...
> JoeyD
> If I remember well, database mirroring is supported only on Enterprise
> Edition
>
> "JoeyD" <joeydba@.gmail.com> wrote in message
> news:1168635799.710707.324810@.51g2000cwl.googlegroups.com...
>> Is Asynchronous database mirroring support in the Standard Edition of
>> SQL 2005?
>> I've read some docs that say it isn't. However, my manager saids that
>> he was told it was (or would work), something about 'single stream'? I
>> have not been able to find any docs that talks about 'single stream'.
>> Can anyone advise or point me in the right direction?
>> thanks all,
>> JD
>|||Thanks Paul for the reply. I've done some more testing on my own and
have found this to be true. Not sure what my manager had heard or where
he had heard it.
Joe
Paul S. Randal [MS] wrote:
> Synchronous mirroring is supported on Standard and Enterprise editions.
> Asynchronous mode is only supported on Enterprise edition.
> --
> Paul Randal
> Principal Lead Program Manager
> Core Storage Engine, Microsoft SQL Server Team
> http://blogs.msdn.com/sqlserverstorageengine/default.aspx
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uh6Amz7NHHA.3916@.TK2MSFTNGP02.phx.gbl...
> > JoeyD
> > If I remember well, database mirroring is supported only on Enterprise
> > Edition
> >
> >
> >
> > "JoeyD" <joeydba@.gmail.com> wrote in message
> > news:1168635799.710707.324810@.51g2000cwl.googlegroups.com...
> >> Is Asynchronous database mirroring support in the Standard Edition of
> >> SQL 2005?
> >>
> >> I've read some docs that say it isn't. However, my manager saids that
> >> he was told it was (or would work), something about 'single stream'? I
> >> have not been able to find any docs that talks about 'single stream'.
> >> Can anyone advise or point me in the right direction?
> >>
> >> thanks all,
> >> JD
> >>
> >
> >

database mirroring question

Thursday, March 22, 2012

Database Mirroring : Asynchronous mirroring without a witness

I am testing the manual failover of a Asynchronous mirroring without a witness but i get the following error when i issue "ALTER DATABASE testdb SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS" on the mirror database server.

Both the mirror and principal is in a synchronized state before i issue the above command.

Msg 1455, Level 16, State 2, Line 1

The database mirroring service cannot be forced for database "testdb" because the database is not in the correct state to become the principal database.

Thanks,

Priyanga

To failover with Asyncronous mirroring, the preferred way to failover is to turn the safety to FULL and issue the ALTER DB SET PARTNER FAILOVER command. that way you will not lose any data when you failover.

The FORCE_SERVICE_ALLOW_DATA_LOSS command should only be used when the principal database is completely broken and it has been decided (by humans) that the mirror server should be promoted to be the new principal. Then the command is issued on the mirror.

State 2 indicates that you are issuing the command on the principal. FORCE_SERVICE can only be issued on the mirror and the mirror cannot talk to the principal.

thanks,
mark

|||

Thanks Mark.

The partner force_service_allow_data_loss command will only work on the mirror when the principal server is not reachable.

Cheers,
Priyanga

Database Mirroring

I'd like to verify that to use Asynchronous database mirroring is NOT
support for Standard Edition.
I've read some docs that say it isn't. However, my manager saids that
he was told it was (or would work), something about 'single stream'? I
have not been able to find any docs that talks about 'single stream'.
Can anyone advise or point me in the right direction?
thanks all,
JD
Standard Edition Database Mirroring is supported as follows:
Single REDO thread and the safety setting is always on.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
"JoeyD" wrote:

> I'd like to verify that to use Asynchronous database mirroring is NOT
> support for Standard Edition.
> I've read some docs that say it isn't. However, my manager saids that
> he was told it was (or would work), something about 'single stream'? I
> have not been able to find any docs that talks about 'single stream'.
> Can anyone advise or point me in the right direction?
> thanks all,
> JD
>
sql

Database Mirroring

I'd like to verify that to use Asynchronous database mirroring is NOT
support for Standard Edition.
I've read some docs that say it isn't. However, my manager saids that
he was told it was (or would work), something about 'single stream'? I
have not been able to find any docs that talks about 'single stream'.
Can anyone advise or point me in the right direction?
thanks all,
JDStandard Edition Database Mirroring is supported as follows:
Single REDO thread and the safety setting is always on.
http://www.microsoft.com/sql/prodin...e-features.mspx
"JoeyD" wrote:

> I'd like to verify that to use Asynchronous database mirroring is NOT
> support for Standard Edition.
> I've read some docs that say it isn't. However, my manager saids that
> he was told it was (or would work), something about 'single stream'? I
> have not been able to find any docs that talks about 'single stream'.
> Can anyone advise or point me in the right direction?
> thanks all,
> JD
>

Sunday, March 25, 2012

database mirroring question

database mirroring question

database mirroring question

Thursday, March 22, 2012

Database Mirroring : Asynchronous mirroring without a witness

Database Mirroring

Database Mirroring

Database Overwritten

Blog Archive

About Me