如何在MS SQL Server 2005 做 mirroring snapshot

YoshiHan

如题。。谢谢大家的帮助。

soonyu

Mirroring and snapshot is 2 diffrent thing
Snapshot will dump structure of db (source db) which you want to snapshot
Snapshot didn't contain data when create,
each change in the source db will copy the orignal page to snapshot db.

Mirroring a method which enable us to maintain a hot warm standy server with auto fail over and no data latency.
That is 3 mode of mirroring
- High Availability Operating mode (auto failover)
- High Performance Operating mode  (manual failover)
- High Protection Operating mode (use when want replace witness)

to create snapshot db
- create database snapshottest
(Name = 'test_data'
Filename = 'c:\test\snapshottest.ds')
as snapshot of pubs

for db mirroring, it much complex and I still no try yet.
but detail found in Mircorosft data mirroring

Cheers,
soonyu