Re: Another Mirroring Question

Answered my own question

So these are the steps for other newbs out there.

1. Backup database
2. Backup transaction log
3. restore database on mirror server - make sure to set NO RECOVERY option,
2nd option
4 restore database transaction logs -- make sure again to set NO RECOVERY
5. configure security
6. start mirroring.

Wish that process was simpler, I have 40 databases! Anyone have some
scripts to automate this?

Dennis


"Dennis Burgess" <dmburgess@xxxxxxxxxxxx> wrote in message
news:%23MYgNn0hGHA.1508@xxxxxxxxxxxxxxxxxxxxxxx
When I try to start my mirror,

I get the following error: My mirror server db changes from "restoring.."
to "in recovery"...

But thats about it. I have been following along, I restore the database,
checked the proper restore mode. ideas?


TITLE: Database Properties
------------------------------

An error occurred while starting mirroring.

------------------------------
ADDITIONAL INFORMATION:

Alter failed for Database 'DONTDIAL'. (Microsoft.SqlServer.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server network address "TCP://sc-server2.xxx.com:5022" can not be
reached or does not exist. Check the network address name and that the
ports for the local and remote endpoints are operational. (Microsoft SQL
Server, Error: 1418)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------




.