VHP6wBap

1use simpleDBWChmielarz
2
3if exists(select * from sys.databases where name='simpleDBWChmielarz')
4drop database simpleDBWChmielarz
5
6create database simpleDBWChmielarz
7
8drop table dbo.simpleTab
9
10create table dbo.simpleTab(id int not null primary key identity(1,1), val int not null)
11insert into dbo.simpleTab (val) values(10)
12insert into dbo.simpleTab (val) values(15)
13insert into dbo.simpleTab (val) values(20)
14select * from simpleTab
15
16ALTER DATABASE simpleDBWChmielarz SET RECOVERY FULL
17BACKUP DATABASE simpleDBWChmielarz TO DISK='C:\bd3\WChmielarz\simpleDBWChmielarz.bak'
18BACKUP LOG simpleDBWChmielarz TO DISK='C:\bd3\WChmielarz\simpleDBWChmielarzLog.bak'
19
20CREATE ENDPOINT Endpoint_PrincipialWChmielarz
21STATE = STARTED
22AS TCP ( LISTENER_PORT = 7024 )
23FOR DATABASE_MIRRORING ( ROLE = PARTNER )
24
25select * from sys.database_mirroring_endpoints
26IF EXISTS (select * from sys.database_mirroring_endpoints where name='Endpoint_PrincipialWChmielarz')
27DROP ENDPOINT Endpoint_PrincipialWChmielarz
28
29select name, state, state_desc from sys.database_mirroring_endpoints where name='Endpoint_PrincipialWChmielarz'
30
31ALTER DATABASE simpleDBWChmielarz SET PARTNER OFF
32ALTER DATABASE simpleDBWChmielarz SET PARTNER = 'tcp://127.0.0.1:7025' 
33
34select dbs.name, mir.mirroring_state_desc, mir.mirroring_safety_level, mirroring_partner_instance from sys.database_mirroring as mir
35inner join sys.databases as dbs
36on mir.database_id = dbs.database_id
37where mirroring_guid is not null
38
39select * from sys.database_mirroring