Replicating a content DB in V3

I am trying to use snap shot replication using SQL 2005 in a V3 in a
environment from one instance to another.

I am having trouble with the content db I get the following error
which I see someone else has encountered and did not get an asnwer
for.

I presume this will happen in WSS or MOSS because the same table is
created by default for the content db.

Does anyone know if this has been addressed or if there is a work
around?

Error messages:

Source: Microsoft.SqlServer.Smo
Target Site: System.Collections.Specialized.StringCollection
ScriptWithList(Microsoft.SqlServer.Management.Smo.DependencyCollection,
Microsoft.SqlServer.Management.Smo.SqlSmoObject[])


Message: Script failed for Table 'dbo.NameValuePair_Hindi_CI_AS'.






Stack: at
Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection
depList, SqlSmoObject[] objects)
at
Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(SqlSmoObject[]
objects)
at
Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateLogBasedArticleSchScript(Scripter
scripter, BaseArticleWrapper articleWrapper, Table smoTable)
at
Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateLogBasedArticleScripts(ArticleScriptingBundle
articleScriptingBundle)
at
Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateArticleScripts(ArticleScriptingBundle
articleScriptingBundle)
at
Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.GenerateObjectScripts(ArticleScriptingBundle
articleScriptingBundle)
at
Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.DoScripting()
at
Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.DoScripting()
at
Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
at
Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source:
Microsoft.SqlServer.Smo, Error number: 0)

Hulicat
Sun Mar 16 10:44:29 CDT 2008

Question:
Has anyone been able to do "snap shot" replication on a content db in
V3 moss or wss?

I should be able to figure this out since I am SQL and MOSS certified
but it dies everytime on the same table in multiple environmets.

I can replicated other dbs just not the content dbs.

BTW: out of the "fabulous 40" templates does anyone have the kb
template deployed? If so go check the site GUID.....you may be
surprised at what you see :(

Hulicat
Wed Mar 19 09:32:43 CDT 2008

I finally was able to setup a "Snap Shot" publication and subscription
on a content db.

The process I had to use.
1. Take a full backup of source database and restore it to target.
2. Create a Snap Shot publication on the source and omit all of the
language specific data i.e NameValuePair_Vietnamese_CI_AS, etc

3. Create a subcription on the target and sync.

Since we only use English I do not expect there to be any issue; I am
not sure why any of the language specific tables will not replicate, I
suspect it is some collation issue?

I saw on the DB boards where this issue was not addressed; I am going
to follow up with MSFT to validate the issue and whether or not my
work around is okay.

Regards,
Dennis