Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can i create an initial snapshot in transactional replication with Standard edition Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2012 12:17 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 10:22 AM
Points: 93, Visits: 594
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
Post #1376621
Posted Thursday, October 25, 2012 6:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 2:51 AM
Points: 13, Visits: 168
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)
Post #1376953
Posted Thursday, October 25, 2012 6:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:09 AM
Points: 6,479, Visits: 13,940
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"
Post #1376958
Posted Thursday, October 25, 2012 7:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 2:51 AM
Points: 13, Visits: 168
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.
Post #1376991
Posted Thursday, October 25, 2012 8:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:09 AM
Points: 6,479, Visits: 13,940
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"
Post #1377003
Posted Thursday, October 25, 2012 9:10 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 10:22 AM
Points: 93, Visits: 594
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.
Post #1377064
Posted Friday, October 26, 2012 1:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:09 AM
Points: 6,479, Visits: 13,940
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"
Post #1377426
Posted Friday, October 26, 2012 9:12 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 10:22 AM
Points: 93, Visits: 594
Thanks, Perry, I appreciate the help! I'm going to have to do a lot of reading and testing on this... Off to work!
Post #1377669
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse