Sql Server Mirror Problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Sql Server Mirror Problem

Author

Topic

pkuchaliya
Starting Member

49 Posts

Posted - 2009-08-18 : 09:49:05

Hi To all,

I m Facing the problem to mirroring database.Currently i m working on the sql server 2005 developer edition.
I follow these step .
On Server side

1.Add ;-T1400 in Start up Parameter in advance property in sql service.

2.ALTER DATABASE <Database Name>SET SAFETY FULL;

3.ALTER DATABASE <Database Name>
SET RECOVERY FULL;
GO

4.CREATE ENDPOINT <Endpointname>
STATE=STARTED
AS TCP (LISTENER_PORT=7022)
FOR DATABASE_MIRRORING (ROLE=PARTNER)
GO

5.GRANT CONNECT ON ENDPOINT::<Endpointname> TO [loginname];
GO

6.ALTER DATABASE <Database name>
SET PARTNER = 'TCP://dimatserver:7022'
GO

7.USE <Databasename>
GO
BACKUP DATABASE <Databasename>
TO DISK = <path>
WITH FORMAT,
MEDIANAME = 'Z_SQLServerBackups',
NAME = 'Full Backup of testmirror';
GO

8.ALTER ENDPOINT <endpoint>
FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = SUPPORTED)

>>>>>>>>>>>>>> But when i Execute 6. query it does not find the path.
all other query executed successfully.

on client side
1.BACKUP database testmirror TO DISK='D:\database\Backup\TestMirror_FULL.bak'

2.backup log testmirror to disk='D:\database\Backup\TestMirror_log.bak' with no_truncate

3.restore database testmirror from disk='D:\database\Backup\TestMirror_FULL.bak'
with norecovery

4.RESTORE LOG TestMirror from disk='D:\database\Backup\TestMirror_LOG.bak' with norecovery

5.CREATE ENDPOINT Endpoint_Mirroring
STATE=STARTED
AS TCP (LISTENER_PORT=7022)
FOR DATABASE_MIRRORING (ROLE=ALL)
GO

----------

6.GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [loginid];
GO

---------------------------
7.ALTER DATABASE testmirror
SET PARTNER =
'TCP://Pankaj:7022'
GO

8.ALTER ENDPOINT endpoint_mirroring
FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = SUPPORTED)
>>>>>>>>>>>>>>>>>>> here all query executed success fully.

And I have also off the firewall on both side. and also check the port connection by using telnet command.
but still i m not able to mirror database.

Please give me suggestion.
Thanks in advance.

pankaj

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources