restoring to a mirrored database

#11

On Apr 26, 2:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:

Quote:

Are you attempting the restore on the principal or on the mirror?

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHollo... (AT) gmail (DOT) com> wrote in message

news:af10aac4-fae7-4a64-baf8-9592cf7571f7 (AT) b64g2000hsa (DOT) googlegroups.com...

When I tried to run the command
alter database Press_Ganey_Associates_MSCRM set single_user with
rollback after 30
on a mirrored database, I got the following error.
Msg 1468, Level 16, State 1, Line 1
The operation cannot be performed on database "myDB" because it is
involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

When restoring to a mirrored database, do I need to pause the
mirroring, or stop it? Once restored, do I simply resume or set on?

On the principal.

#12

On Apr 26, 2:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:

Quote:

Are you attempting the restore on the principal or on the mirror?

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHollo... (AT) gmail (DOT) com> wrote in message

news:af10aac4-fae7-4a64-baf8-9592cf7571f7 (AT) b64g2000hsa (DOT) googlegroups.com...

When I tried to run the command
alter database Press_Ganey_Associates_MSCRM set single_user with
rollback after 30
on a mirrored database, I got the following error.
Msg 1468, Level 16, State 1, Line 1
The operation cannot be performed on database "myDB" because it is
involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

When restoring to a mirrored database, do I need to pause the
mirroring, or stop it? Once restored, do I simply resume or set on?

On the principal.

#13

On Apr 26, 2:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:

Quote:

Are you attempting the restore on the principal or on the mirror?

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHollo... (AT) gmail (DOT) com> wrote in message

news:af10aac4-fae7-4a64-baf8-9592cf7571f7 (AT) b64g2000hsa (DOT) googlegroups.com...

When I tried to run the command
alter database Press_Ganey_Associates_MSCRM set single_user with
rollback after 30
on a mirrored database, I got the following error.
Msg 1468, Level 16, State 1, Line 1
The operation cannot be performed on database "myDB" because it is
involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

When restoring to a mirrored database, do I need to pause the
mirroring, or stop it? Once restored, do I simply resume or set on?

On the principal.

#14

On Apr 26, 2:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:

Quote:

Are you attempting the restore on the principal or on the mirror?

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHollo... (AT) gmail (DOT) com> wrote in message

news:af10aac4-fae7-4a64-baf8-9592cf7571f7 (AT) b64g2000hsa (DOT) googlegroups.com...

When I tried to run the command
alter database Press_Ganey_Associates_MSCRM set single_user with
rollback after 30
on a mirrored database, I got the following error.
Msg 1468, Level 16, State 1, Line 1
The operation cannot be performed on database "myDB" because it is
involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

When restoring to a mirrored database, do I need to pause the
mirroring, or stop it? Once restored, do I simply resume or set on?

On the principal.

#15

On Apr 26, 2:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:

Quote:

Are you attempting the restore on the principal or on the mirror?

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHollo... (AT) gmail (DOT) com> wrote in message

news:af10aac4-fae7-4a64-baf8-9592cf7571f7 (AT) b64g2000hsa (DOT) googlegroups.com...

When I tried to run the command
alter database Press_Ganey_Associates_MSCRM set single_user with
rollback after 30
on a mirrored database, I got the following error.
Msg 1468, Level 16, State 1, Line 1
The operation cannot be performed on database "myDB" because it is
involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

When restoring to a mirrored database, do I need to pause the
mirroring, or stop it? Once restored, do I simply resume or set on?

On the principal.

#16

On Apr 26, 2:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:

Quote:

Are you attempting the restore on the principal or on the mirror?

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHollo... (AT) gmail (DOT) com> wrote in message

news:af10aac4-fae7-4a64-baf8-9592cf7571f7 (AT) b64g2000hsa (DOT) googlegroups.com...

When I tried to run the command
alter database Press_Ganey_Associates_MSCRM set single_user with
rollback after 30
on a mirrored database, I got the following error.
Msg 1468, Level 16, State 1, Line 1
The operation cannot be performed on database "myDB" because it is
involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

When restoring to a mirrored database, do I need to pause the
mirroring, or stop it? Once restored, do I simply resume or set on?

On the principal.

#17

On Apr 26, 2:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:

Quote:

Are you attempting the restore on the principal or on the mirror?

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHollo... (AT) gmail (DOT) com> wrote in message

news:af10aac4-fae7-4a64-baf8-9592cf7571f7 (AT) b64g2000hsa (DOT) googlegroups.com...

When I tried to run the command
alter database Press_Ganey_Associates_MSCRM set single_user with
rollback after 30
on a mirrored database, I got the following error.
Msg 1468, Level 16, State 1, Line 1
The operation cannot be performed on database "myDB" because it is
involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

When restoring to a mirrored database, do I need to pause the
mirroring, or stop it? Once restored, do I simply resume or set on?

On the principal.

#18

On Apr 26, 2:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:

Quote:

Are you attempting the restore on the principal or on the mirror?

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHollo... (AT) gmail (DOT) com> wrote in message

news:af10aac4-fae7-4a64-baf8-9592cf7571f7 (AT) b64g2000hsa (DOT) googlegroups.com...

When I tried to run the command
alter database Press_Ganey_Associates_MSCRM set single_user with
rollback after 30
on a mirrored database, I got the following error.
Msg 1468, Level 16, State 1, Line 1
The operation cannot be performed on database "myDB" because it is
involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

When restoring to a mirrored database, do I need to pause the
mirroring, or stop it? Once restored, do I simply resume or set on?

On the principal.

#19

On Apr 26, 2:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:

Quote:

Are you attempting the restore on the principal or on the mirror?

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHollo... (AT) gmail (DOT) com> wrote in message

news:af10aac4-fae7-4a64-baf8-9592cf7571f7 (AT) b64g2000hsa (DOT) googlegroups.com...

When I tried to run the command
alter database Press_Ganey_Associates_MSCRM set single_user with
rollback after 30
on a mirrored database, I got the following error.
Msg 1468, Level 16, State 1, Line 1
The operation cannot be performed on database "myDB" because it is
involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

When restoring to a mirrored database, do I need to pause the
mirroring, or stop it? Once restored, do I simply resume or set on?

On the principal.

#20

You can't restore the principal, this would break the mirroring anyway, so you have to stop
mirroring, do the restore and then re do the mirroring setup. See for instance:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/f28f0fb8-c18a-4fc6-96ac-2e7a8ff189cd.htm

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHolloway (AT) gmail (DOT) com> wrote

Quote:

On Apr 26, 2:37 am, "Tibor Karaszi"
tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:
Are you attempting the restore on the principal or on the mirror?

--
Tibor Karaszi, SQL Server
MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"JOH" <JOHollo... (AT) gmail (DOT) com> wrote in message

news:af10aac4-fae7-4a64-baf8-9592cf7571f7 (AT) b64g2000hsa (DOT) googlegroups.com...

When I tried to run the command
alter database Press_Ganey_Associates_MSCRM set single_user with
rollback after 30
on a mirrored database, I got the following error.
Msg 1468, Level 16, State 1, Line 1
The operation cannot be performed on database "myDB" because it is
involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

When restoring to a mirrored database, do I need to pause the
mirroring, or stop it? Once restored, do I simply resume or set on?

On the principal.