bjcharles (10/25/2012)
Perry Whittle (10/25/2012)
Elizabeth.Block (10/24/2012)
I don't know much about transactional replication and we're going to implement this soon on a SQL Server 2008 Standard server. I'd heard that you can't create a snapshot in SQL 2008 Standard. Is this correct? It seems like it must be since replication is supported in all editions of SQL 2008. Any info is greatly appreciated!Elizabeth
database snapshots are a feature of the Enterprise product is this what you are referring too?
Aha, database snapshot is not related to snapshots in Sql svr replication. Database snapshot, an enterprise feature, simply gives you a read only clone of your DB the way it looked at a point in time. Snapshots in replication is handled by the sql svr snapshot agent and it just takes a 'snapshot' of objects to be published before the other repl events take over.
Hence why i asked the OP if they were referring to database snapshots as this is where the restriction between Ent and Std lies 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉