on 01-05-2010 1:45 PM
Some DB allows only one snapshot-- any newer snapshot will overwrite the old one. Is this true for SQLserver as well?
Thanks!
Hi,
not true:
A database snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and always reside on the same server instance as the database. Each database snapshot is transactionally consistent with the source database as of the moment of the snapshot's creation. A snapshot persists until it is explicitly dropped by the database owner.
Please consult BOL on this [issue|http://msdn.microsoft.com/en-us/library/ms175158.aspx].
Sven
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.