Dave Stringfellow
asked on
SQL 2008 Replication
We are testing ways of backing up are SQL database using replication.
So I have a test setup of 2 servers both systems running server 2008, with SQL server 2008 running.
Ive imported our database and created a local publication on one machine.
Then on the 2nd machine, the subcription is running successfully.
The problem is the snapshop agent fails during the replication with the error:
Message: Script failed for Table 'dbo.sysdiagrams'.
heres the rest of the error message:
Source: Microsoft.SqlServer.Smo
Target Site: System.Collections.Generic .IEnumerab le`1[Syste m.String] ScriptWithList(Microsoft.S qlServer.M anagement. Smo.Depend encyCollec tion, Microsoft.SqlServer.Manage ment.Smo.S qlSmoObjec t[])
Message: Script failed for Table 'dbo.sysdiagrams'.
Stack: at Microsoft.SqlServer.Manage ment.Smo.S cripter.Sc riptWithLi st(Depende ncyCollect ion depList, SqlSmoObject[] objects)
at Microsoft.SqlServer.Manage ment.Smo.S cripter.Sc riptWithLi st(SqlSmoO bject[] objects)
at Microsoft.SqlServer.Replic ation.Snap shot.Trans SmoScripti ngManager. GenerateLo gBasedArti cleSchScri pt(Scripte r scripter, BaseArticleWrapper articleWrapper, Table smoTable)
at Microsoft.SqlServer.Replic ation.Snap shot.Trans SmoScripti ngManager. GenerateLo gBasedArti cleScripts (ArticleSc riptingBun dle articleScriptingBundle)
at Microsoft.SqlServer.Replic ation.Snap shot.Trans SmoScripti ngManager. GenerateAr ticleScrip ts(Article ScriptingB undle articleScriptingBundle)
at Microsoft.SqlServer.Replic ation.Snap shot.SmoSc riptingMan ager.Gener ateObjectS cripts(Art icleScript ingBundle articleScriptingBundle)
at Microsoft.SqlServer.Replic ation.Snap shot.SmoSc riptingMan ager.DoScr ipting()
at Microsoft.SqlServer.Replic ation.Snap shot.SqlSe rverSnapsh otProvider .DoScripti ng()
at Microsoft.SqlServer.Replic ation.Snap shot.SqlSe rverSnapsh otProvider .GenerateS napshot()
at Microsoft.SqlServer.Replic ation.Snap shotGenera tionAgent. InternalRu n()
at Microsoft.SqlServer.Replic ation.Agen tCore.Run( ) (Source: Microsoft.SqlServer.Smo, Error number: 0)
Get help: http://help/0
Source: Microsoft.SqlServer.Smo
Target Site: Void CheckSupportedType(Microso ft.SqlServ er.Managem ent.Smo.Sc riptingOpt ions)
Message: Column definition in object sysdiagrams contains type VarBinaryMax, which is not supported in the target server version, SQL Server 2000.
Stack: at Microsoft.SqlServer.Manage ment.Smo.C olumn.Chec kSupported Type(Scrip tingOption s options)
at Microsoft.SqlServer.Manage ment.Smo.C olumn.Vers ionValidat e(Scriptin gOptions so)
at Microsoft.SqlServer.Manage ment.Smo.C olumn.Scri ptDdlCreat eImpl(Stri ngBuilder sb, ScriptingOptions so)
at Microsoft.SqlServer.Manage ment.Smo.C olumn.Scri ptDdl(Stri ngCollecti on queries, ScriptingOptions so)
at Microsoft.SqlServer.Manage ment.Smo.T able.Scrip tTableInte rnal(Scrip tingOption s so, StringBuilder sb, ColumnCollection columns, IndexCollection indexes)
at Microsoft.SqlServer.Manage ment.Smo.T able.GetTa bleCreatio nScript(Sc riptingOpt ions so, StringBuilder sb)
at Microsoft.SqlServer.Manage ment.Smo.T able.Scrip tCreate(St ringCollec tion queries, ScriptingOptions so)
at Microsoft.SqlServer.Manage ment.Smo.S qlSmoObjec t.ScriptCr eateIntern al(StringC ollection query, ScriptingOptions so)
at Microsoft.SqlServer.Manage ment.Smo.S cripter.Sc riptWithLi stWorker(D ependencyC ollection depList, SqlSmoObject[] objects)
at Microsoft.SqlServer.Manage ment.Smo.S cripter.Sc riptWithLi st(Depende ncyCollect ion depList, SqlSmoObject[] objects) (Source: Microsoft.SqlServer.Smo, Error number: 0)
Get help: http://help/0
Thanks
So I have a test setup of 2 servers both systems running server 2008, with SQL server 2008 running.
Ive imported our database and created a local publication on one machine.
Then on the 2nd machine, the subcription is running successfully.
The problem is the snapshop agent fails during the replication with the error:
Message: Script failed for Table 'dbo.sysdiagrams'.
heres the rest of the error message:
Source: Microsoft.SqlServer.Smo
Target Site: System.Collections.Generic
Message: Script failed for Table 'dbo.sysdiagrams'.
Stack: at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Replic
at Microsoft.SqlServer.Replic
at Microsoft.SqlServer.Replic
at Microsoft.SqlServer.Replic
at Microsoft.SqlServer.Replic
at Microsoft.SqlServer.Replic
at Microsoft.SqlServer.Replic
at Microsoft.SqlServer.Replic
at Microsoft.SqlServer.Replic
Get help: http://help/0
Source: Microsoft.SqlServer.Smo
Target Site: Void CheckSupportedType(Microso
Message: Column definition in object sysdiagrams contains type VarBinaryMax, which is not supported in the target server version, SQL Server 2000.
Stack: at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
Get help: http://help/0
Thanks
ASKER
Could you expand on your answer?
Were looking for fault tolorence without using clustering. would this method provide a solution?
Thanks
Were looking for fault tolorence without using clustering. would this method provide a solution?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
why don't you use mirroring and log shipping?