October 24, 2012 at 12:17 pm
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
October 25, 2012 at 6:37 am
Transactional replication indeed starts with a db snapshot, even in Std edition, after which subsequent changes at the publisher are monitored for near real time transfer to the subscriber(s)
October 25, 2012 at 6:50 am
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2012 at 7:45 am
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.
October 25, 2012 at 8:00 am
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" 😉
October 25, 2012 at 9:10 am
Thank you both for your replies! I thought that database snapshots might be the same as the snapshots used for replication but wasn't sure. Can the snapshot for replication be made by the replication wizard.
October 26, 2012 at 1:42 am
Elizabeth.Block (10/25/2012)
Thank you both for your replies! I thought that database snapshots might be the same as the snapshots used for replication but wasn't sure.
You're welcome. I guessed that's where you were getting confused.
Elizabeth.Block (10/25/2012)
Can the snapshot for replication be made by the replication wizard.
When you setp through the wizard there is an option to have the agent generate the snapshot immediately or later. Go through this first in your test system to ensure you're comfortable with the steps
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2012 at 9:12 am
Thanks, Perry, I appreciate the help! I'm going to have to do a lot of reading and testing on this... Off to work!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply