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.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-10-26 : 10:31:29
|
| I have created a snapshotCREATE DATABASE AdventureWorks_Snapshot1200 ON(NAME = N'AdventureWorks_Data', FILENAME= N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AW_1200.ss')AS SNAPSHOT Of AdventureWorksI changed the records AddressLine1 from 1970 Napa Ct. to 1970 Napa Ct. Apt 1When i runselect * from Person.Address AventureWorks_Snapshot1200 where addressid = '1'select * from Person.Address AventureWorks where addressid = '1' Both appear as 1When i change Apt to 2 and run it both appear 2I was under the impression that the snapshot would remain as 1 when the new update 2 has been performed.Any light be appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-26 : 11:27:09
|
| Duplicate, locking thread.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Database snapshot