Arenear
18-05-2010, 14:24
используется SQL server 2005 Standart SP3
есть 2 сервера vm1 - principal, vm2 - mirror, на основном сервере база данных dest
на основном сервере:
dbcc traceon(1400, -1)
exec dbo.sp_dbcmptlevel @dbname = N'dest', @new_cmptlevel = 90
select recovery_model_desc from sys.databases where name = 'dest'
backup database dest to disk = 'c:\dest\dest.bak' with format
backup log dest to disk = 'c:\dest\dest.ldf' with format
на зеркале:
dbcc traceon(1400, -1)
restore database dest from disk = 'c:\dest\dest.bak' with norecovery
restore log dest from disk = 'c:\dest\dest.ldf' with norecovery
на зеркальном сервере создается база dest (Restoring...)
на обоих серверах создаю конечные точки:
create endpoint mirroring
state = started
as tcp (listener_port = 5022, listener_ip = all)
for database_mirroring (role = partner)
на запрос:
select dme.name,
dme.protocol_desc,
dme.type_desc,
dme.state_desc,
role_desc,
te.port,
te.ip_address
from sys.database_mirroring_endpoints as dme
inner join sys.tcp_endpoints as te on te.endpoint_id = dme.endpoint_id
выдает:
mirroring TCP DATABASE_MIRRORING STARTED PARTNER 5022 NULL
далее, на основном сервере:
alter database dest set partner = 'tcp://vm2:5022'
Msg 1486, Level 14, State 2, Line 26
Database Mirroring Transport is disabled in the endpoint configuration.
Заранее благодарю откликнувшихся
есть 2 сервера vm1 - principal, vm2 - mirror, на основном сервере база данных dest
на основном сервере:
dbcc traceon(1400, -1)
exec dbo.sp_dbcmptlevel @dbname = N'dest', @new_cmptlevel = 90
select recovery_model_desc from sys.databases where name = 'dest'
backup database dest to disk = 'c:\dest\dest.bak' with format
backup log dest to disk = 'c:\dest\dest.ldf' with format
на зеркале:
dbcc traceon(1400, -1)
restore database dest from disk = 'c:\dest\dest.bak' with norecovery
restore log dest from disk = 'c:\dest\dest.ldf' with norecovery
на зеркальном сервере создается база dest (Restoring...)
на обоих серверах создаю конечные точки:
create endpoint mirroring
state = started
as tcp (listener_port = 5022, listener_ip = all)
for database_mirroring (role = partner)
на запрос:
select dme.name,
dme.protocol_desc,
dme.type_desc,
dme.state_desc,
role_desc,
te.port,
te.ip_address
from sys.database_mirroring_endpoints as dme
inner join sys.tcp_endpoints as te on te.endpoint_id = dme.endpoint_id
выдает:
mirroring TCP DATABASE_MIRRORING STARTED PARTNER 5022 NULL
далее, на основном сервере:
alter database dest set partner = 'tcp://vm2:5022'
Msg 1486, Level 14, State 2, Line 26
Database Mirroring Transport is disabled in the endpoint configuration.
Заранее благодарю откликнувшихся