 |
|
|
|
Next: SQL server insufficient system memory...
|
| Author |
Message |
External
Since: Apr 07, 2008
Posts: 38
|
(Msg. 1) Posted: Fri Apr 25, 2008 2:37 pm
Post subject: restoring to a mirrored database
Archived from groups: microsoft>public>sqlserver>server (more info?)
|
|
|
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? |
|
| Back to top |
|
 | |
External
Since: Jan 29, 2004
Posts: 1559
|
(Msg. 2) Posted: Sat Apr 26, 2008 8:37 am
Post subject: Re: restoring to a mirrored database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
> 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? |
|
| Back to top |
|
| |
External
Since: Apr 07, 2008
Posts: 38
|
(Msg. 3) Posted: Sat Apr 26, 2008 4:31 pm
Post subject: Re: restoring to a mirrored database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Apr 26, 2:37 am, "Tibor Karaszi"
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/blog...ibor_ka
>
> "JOH" wrote in message
>
>
>
> > 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. >> Stay informed about: restoring to a mirrored database |
|
| Back to top |
|
| |
External
Since: Jan 29, 2004
Posts: 1559
|
(Msg. 4) Posted: Sun Apr 27, 2008 8:09 pm
Post subject: Re: restoring to a mirrored database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
> On Apr 26, 2:37 am, "Tibor Karaszi"
> 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/blog...ibor_ka
>>
>> "JOH" wrote in message
>>
>>
>>
>> > 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. >> Stay informed about: restoring to a mirrored database |
|
| Back to top |
|
| |
External
Since: Apr 07, 2008
Posts: 38
|
(Msg. 5) Posted: Mon Apr 28, 2008 3:33 pm
Post subject: Re: restoring to a mirrored database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Apr 27, 2:09 pm, "Tibor Karaszi"
wrote:
> 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 MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blog...ibor_ka
>
> "JOH" wrote in message
>
>
>
> > On Apr 26, 2:37 am, "Tibor Karaszi"
> > 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/...
>
> >> "JOH" wrote in message
>
> >>
>
> >> > 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.
Thank you for the link. I've now read through the BOL on mirroring,
and will experiment with test instances. >> Stay informed about: restoring to a mirrored database |
|
| Back to top |
|
| |
External
Since: Dec 21, 2011
Posts: 1
|
(Msg. 6) Posted: Wed Dec 21, 2011 7:26 pm
Post subject: Re: Re: restoring to a mirrored database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Msg 1468, Level 16, State 5, Line 1
The operation cannot be performed on database "DBNTE033" because it is involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
> On Saturday, April 26, 2008 2:37 AM Tibor Karaszi wrote:
> 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
>> On Saturday, April 26, 2008 1:05 PM JOH wrote:
>> 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 Sunday, April 27, 2008 2:09 PM Tibor Karaszi wrote:
>>> 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" wrote in message
>>>
>>>> On Monday, April 28, 2008 1:36 AM JOH wrote:
>>>> On the principal.
>>>>> On Wednesday, April 30, 2008 7:00 AM JOH wrote:
>>>>> Thank you for the link. I have now read through the BOL on mirroring,
>>>>> and will experiment with test instances. >> Stay informed about: restoring to a mirrored database |
|
| Back to top |
|
| |
| Related Topics: | Restoring a database - I'm trying to restore a SQL 2005 database. First I restore the last full backup: RESTORE DATABASE OnTrack_Test_2 FROM DISK='C:\b\ReportServer_backup_200612170300.bak' with move 'ReportServer' to 'C:\data\OnTrack_Test_2.mdf', move 'ReportServer_log' to..
Problem with restoring a database - Hello! I use SQL Server 2005. I have a backup taken from a computer that had the following definition when I started SQL Server - Server type: Database Engine - Server name: UHTDEMO5 -Authentication: Windows Authentication -Username: UHTDEMO5\anvd The....
restoring database from multiple backup files - Hello, I have a database that needs to be refreshed from time to time. THe only thing is, the size is quite large and i have to send it to a remote site. So from EM i simply back it up to 5 files (small enough to zip them), copy, unzip and then load....
Deleting an ID issue in SQL2005 after restoring a SQL 7 da.. - Restored a Production SQL Server 7 Database to SQL Server 2005 running on a test server. The ID for a user account that existed on the restored database duplicates an ID on the test server. The ID on the restored Database cannot be deleted because it....
Replicating mirrored dbs - Hello, We're looking to replicate Database A to Database B. (transactional DB to a reporting server). Both database A and database B are mirrored. Can we setup replication from database A to database B and have failover not interupt replication? I've .... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
