dbTalk Databases Forums  

restoring to a mirrored database

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.server restoring to a mirrored database

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss restoring to a mirrored database in the microsoft.public.sqlserver.server forum.



Reply
Page 1 of 4 1 2 3 4 >
 
Thread Tools Display Modes
  #1  
Old   
JOH
 
Posts: n/a

Default restoring to a mirrored database - 04-25-2008 , 04:37 PM





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?

Reply With Quote
  #2  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: restoring to a mirrored database - 04-26-2008 , 01:37 AM





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

--
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:
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?


Reply With Quote
  #3  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: restoring to a mirrored database - 04-26-2008 , 01:37 AM


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

--
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:
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?


Reply With Quote
  #4  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: restoring to a mirrored database - 04-26-2008 , 01:37 AM


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

--
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:
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?


Reply With Quote
  #5  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: restoring to a mirrored database - 04-26-2008 , 01:37 AM


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

--
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:
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?


Reply With Quote
  #6  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: restoring to a mirrored database - 04-26-2008 , 01:37 AM


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

--
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:
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?


Reply With Quote
  #7  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: restoring to a mirrored database - 04-26-2008 , 01:37 AM


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

--
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:
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?


Reply With Quote
  #8  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: restoring to a mirrored database - 04-26-2008 , 01:37 AM


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

--
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:
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?


Reply With Quote
  #9  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: restoring to a mirrored database - 04-26-2008 , 01:37 AM


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

--
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:
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?


Reply With Quote
  #10  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: restoring to a mirrored database - 04-26-2008 , 01:37 AM


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

--
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:
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?


Reply With Quote
Reply
Page 1 of 4 1 2 3 4 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top