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:32
|
| 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. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-10-26 : 23:46:30
|
Your two SELECT statements don't really make sense the way you've typed them, like this they should work correctly:select * from AventureWorks_Snapshot1200.Person.Address where addressid = 1 select * from AventureWorks.Person.Address where addressid = 1 |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-10-27 : 08:41:08
|
| Thanks yes i was in the wrong database when running the queries so i changed it to below thats now makes perfect sense.Cheers |
|
|
|
|
|
|
Database snapshot