| Groups | Blog | Home |
sql server replication : Replication between SQL server and SQL express ????
pre-create it. Can you enable logging so we can see where replication is failing. Use this link to enable it. http://support.microsoft.com/kb/312292 -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "calderara" <calderara@discussions.microsoft.com> wrote in message news:AEDF7E8F-8D58-488E-A3B0-DDCD38575CCF@microsoft.com... > Dear all, > > I try to setup a replication between a database TEST on a server myServer > into an SQL express database myDB on a Vista office PC machine. > > For that I define my SQL server to be a publisher of my database TEST and > then on my Client PC under sqL express I define a new subscription by > selection my SQL server as the publisher. Setup goes fine until it try the > firts initialisation with the only mesage initialisation failed.. > > What do I have to verify ? > > If on my SQL server dtabase I want to publish table EVENT, does that table > need to be already created in my SQL express before initialisation or it > will > created automaticaly ?? > > Which permission type should be use from both side... ? for time beeing I > was using 'sa' > > thnaks for help > rergards > serge
Dear all,
I try to setup a replication between a database TEST on a server myServer into an SQL express database myDB on a Vista office PC machine. For that I define my SQL server to be a publisher of my database TEST and then on my Client PC under sqL express I define a new subscription by selection my SQL server as the publisher. Setup goes fine until it try the firts initialisation with the only mesage initialisation failed.. What do I have to verify ? If on my SQL server dtabase I want to publish table EVENT, does that table need to be already created in my SQL express before initialisation or it will created automaticaly ?? Which permission type should be use from both side... ? for time beeing I was using 'sa' thnaks for help rergards
OK I will try to setup thge login....
Just for you to know that I have use the snaphot method for replication and when I use the replication monitor and press th re iintialize menu...it goes from status running to status fail retry initializing after a while and of course my table is not created on my client machine. Any rigths to verify on my client machine under EXPRES 2005 for the receiving database ? regards [quoted text, click to view] "Hilary Cotter" wrote:
> Replication will create the table for you. There is no need for you to > pre-create it. Can you enable logging so we can see where replication is > failing. > > Use this link to enable it. > > http://support.microsoft.com/kb/312292 > > -- > Hilary Cotter > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "calderara" <calderara@discussions.microsoft.com> wrote in message > news:AEDF7E8F-8D58-488E-A3B0-DDCD38575CCF@microsoft.com... > > Dear all, > > > > I try to setup a replication between a database TEST on a server myServer > > into an SQL express database myDB on a Vista office PC machine. > > > > For that I define my SQL server to be a publisher of my database TEST and > > then on my Client PC under sqL express I define a new subscription by > > selection my SQL server as the publisher. Setup goes fine until it try the > > firts initialisation with the only mesage initialisation failed.. > > > > What do I have to verify ? > > > > If on my SQL server dtabase I want to publish table EVENT, does that table > > need to be already created in my SQL express before initialisation or it > > will > > created automaticaly ?? > > > > Which permission type should be use from both side... ? for time beeing I > > was using 'sa' > > > > thnaks for help > > rergards > > serge > >
I have generated the log file.
I can paste the whol content here ? What I have noticed if I read properly is that the sanphot seems to work ok as when starting the agent I get status complete succesfully.I think the problem come from the time it needs to copy the snapshot to the Client SQL express 2005 database... :-( [quoted text, click to view] "Hilary Cotter" wrote:
> Replication will create the table for you. There is no need for you to > pre-create it. Can you enable logging so we can see where replication is > failing. > > Use this link to enable it. > > http://support.microsoft.com/kb/312292 > > -- > Hilary Cotter > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "calderara" <calderara@discussions.microsoft.com> wrote in message > news:AEDF7E8F-8D58-488E-A3B0-DDCD38575CCF@microsoft.com... > > Dear all, > > > > I try to setup a replication between a database TEST on a server myServer > > into an SQL express database myDB on a Vista office PC machine. > > > > For that I define my SQL server to be a publisher of my database TEST and > > then on my Client PC under sqL express I define a new subscription by > > selection my SQL server as the publisher. Setup goes fine until it try the > > firts initialisation with the only mesage initialisation failed.. > > > > What do I have to verify ? > > > > If on my SQL server dtabase I want to publish table EVENT, does that table > > need to be already created in my SQL express before initialisation or it > > will > > created automaticaly ?? > > > > Which permission type should be use from both side... ? for time beeing I > > was using 'sa' > > > > thnaks for help > > rergards > > serge > >
Yes, please post the whole thing here. It sounds like you might have done
this for the snapshot agent. You may need to do this for the merge/distribution agent as well. -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "calderara" <calderara@discussions.microsoft.com> wrote in message news:3243F73C-43DF-458A-837D-615F57DF16D4@microsoft.com... >I have generated the log file. > I can paste the whol content here ? > > What I have noticed if I read properly is that the sanphot seems to work > ok > as when starting the agent I get status complete succesfully.I think the > problem come from the time it needs to copy the snapshot to the Client SQL > express 2005 database... > :-( > > > "Hilary Cotter" wrote: > >> Replication will create the table for you. There is no need for you to >> pre-create it. Can you enable logging so we can see where replication is >> failing. >> >> Use this link to enable it. >> >> http://support.microsoft.com/kb/312292 >> >> -- >> Hilary Cotter >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "calderara" <calderara@discussions.microsoft.com> wrote in message >> news:AEDF7E8F-8D58-488E-A3B0-DDCD38575CCF@microsoft.com... >> > Dear all, >> > >> > I try to setup a replication between a database TEST on a server >> > myServer >> > into an SQL express database myDB on a Vista office PC machine. >> > >> > For that I define my SQL server to be a publisher of my database TEST >> > and >> > then on my Client PC under sqL express I define a new subscription by >> > selection my SQL server as the publisher. Setup goes fine until it try >> > the >> > firts initialisation with the only mesage initialisation failed.. >> > >> > What do I have to verify ? >> > >> > If on my SQL server dtabase I want to publish table EVENT, does that >> > table >> > need to be already created in my SQL express before initialisation or >> > it >> > will >> > created automaticaly ?? >> > >> > Which permission type should be use from both side... ? for time beeing >> > I >> > was using 'sa' >> > >> > thnaks for help >> > rergards >> > serge >> >> >>
Thanks for your prompt reply..
Where can I find the merge/replication agent ? in my list where I have doen previous steps I have seen only the snapshot agent ? regards serge [quoted text, click to view] "Hilary Cotter" wrote:
> Yes, please post the whole thing here. It sounds like you might have done > this for the snapshot agent. You may need to do this for the > merge/distribution agent as well. > > -- > Hilary Cotter > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "calderara" <calderara@discussions.microsoft.com> wrote in message > news:3243F73C-43DF-458A-837D-615F57DF16D4@microsoft.com... > >I have generated the log file. > > I can paste the whol content here ? > > > > What I have noticed if I read properly is that the sanphot seems to work > > ok > > as when starting the agent I get status complete succesfully.I think the > > problem come from the time it needs to copy the snapshot to the Client SQL > > express 2005 database... > > :-( > > > > > > "Hilary Cotter" wrote: > > > >> Replication will create the table for you. There is no need for you to > >> pre-create it. Can you enable logging so we can see where replication is > >> failing. > >> > >> Use this link to enable it. > >> > >> http://support.microsoft.com/kb/312292 > >> > >> -- > >> Hilary Cotter > >> > >> Looking for a SQL Server replication book? > >> http://www.nwsu.com/0974973602.html > >> > >> Looking for a FAQ on Indexing Services/SQL FTS > >> http://www.indexserverfaq.com > >> > >> > >> > >> "calderara" <calderara@discussions.microsoft.com> wrote in message > >> news:AEDF7E8F-8D58-488E-A3B0-DDCD38575CCF@microsoft.com... > >> > Dear all, > >> > > >> > I try to setup a replication between a database TEST on a server > >> > myServer > >> > into an SQL express database myDB on a Vista office PC machine. > >> > > >> > For that I define my SQL server to be a publisher of my database TEST > >> > and > >> > then on my Client PC under sqL express I define a new subscription by > >> > selection my SQL server as the publisher. Setup goes fine until it try > >> > the > >> > firts initialisation with the only mesage initialisation failed.. > >> > > >> > What do I have to verify ? > >> > > >> > If on my SQL server dtabase I want to publish table EVENT, does that > >> > table > >> > need to be already created in my SQL express before initialisation or > >> > it > >> > will > >> > created automaticaly ?? > >> > > >> > Which permission type should be use from both side... ? for time beeing > >> > I > >> > was using 'sa' > >> > > >> > thnaks for help > >> > rergards > >> > serge > >> > >> > >> > >
Hi hilary,
Here is below the file output requested for the type : "Replication snapshot" part 1 ================================================ 2007-03-21 14:42:57.75 2007-03-21 14:42:57.75 Microsoft (R) SQL Server Snapshot Agent 2007-03-21 14:42:57.75 [Assembly Version = 9.0.242.0, File Version = 9.00.1399.00] 2007-03-21 14:42:57.75 Copyright (C) 1988-2005 Microsoft Corporation. All rights reserved. 2007-03-21 14:42:57.75 The timestamps prepended to the output lines are expressed in terms of UTC time. 2007-03-21 14:42:57.75 User-specified agent parameter values: 2007-03-21 14:42:57.75 -------------------------------------- 2007-03-21 14:42:57.75 -Publisher NOMOS-SRVR 2007-03-21 14:42:57.75 -PublisherDB TEST 2007-03-21 14:42:57.75 -Publication TestPublication 2007-03-21 14:42:57.75 -Distributor NOMOS-SRVR 2007-03-21 14:42:57.75 -DistributorSecurityMode 1 2007-03-21 14:42:57.75 -Output d:\output.txt 2007-03-21 14:42:57.75 -OutputVerboseLevel 2 2007-03-21 14:42:57.75 -XJOBID 0x88F5D8DDCAC5174B953F14E7691E823B 2007-03-21 14:42:57.75 -------------------------------------- 2007-03-21 14:42:57.75 Connecting to Distributor 'NOMOS-SRVR' 2007-03-21 14:42:57.96 2007-03-21 14:42:57.96 SQL Command dump 2007-03-21 14:42:57.96 ================ 2007-03-21 14:42:57.96 Server: NOMOS-SRVR 2007-03-21 14:42:57.96 Database: master 2007-03-21 14:42:57.96 Command Text: sp_helpdistpublisher 2007-03-21 14:42:57.96 Parameters: 2007-03-21 14:42:57.96 @publisher = NOMOS-SRVR 2007-03-21 14:42:57.96 2007-03-21 14:42:57.96 SQL Command dump 2007-03-21 14:42:57.96 ================ 2007-03-21 14:42:57.96 Server: NOMOS-SRVR 2007-03-21 14:42:57.96 Database: distribution 2007-03-21 14:42:57.96 Command Text: select 'id' = convert(int, srvid) from master..sysservers where upper(srvname) = upper(N'NOMOS-SRVR') 2007-03-21 14:42:57.96 Parameters: 2007-03-21 14:42:57.96 2007-03-21 14:42:57.96 SQL Command dump 2007-03-21 14:42:57.96 ================ 2007-03-21 14:42:57.96 Server: NOMOS-SRVR 2007-03-21 14:42:57.96 Database: distribution 2007-03-21 14:42:57.96 Command Text: sp_MShelp_snapshot_agentid 2007-03-21 14:42:57.96 Parameters: 2007-03-21 14:42:57.96 @publisher_id = 0 2007-03-21 14:42:57.96 @publisher_db = TEST 2007-03-21 14:42:57.96 @publication = TestPublication 2007-03-21 14:42:57.96 @job_id = System.Byte[] 2007-03-21 14:42:57.96 2007-03-21 14:42:57.96 SQL Command dump 2007-03-21 14:42:57.96 ================ 2007-03-21 14:42:57.96 Server: NOMOS-SRVR 2007-03-21 14:42:57.96 Database: distribution 2007-03-21 14:42:57.96 Command Text: sp_MShelp_snapshot_agent 2007-03-21 14:42:57.96 Parameters: 2007-03-21 14:42:57.96 @agent_id = 1 2007-03-21 14:42:57.98 2007-03-21 14:42:57.98 SQL Command dump 2007-03-21 14:42:57.98 ================ 2007-03-21 14:42:57.98 Server: NOMOS-SRVR 2007-03-21 14:42:57.98 Database: distribution 2007-03-21 14:42:57.98 Command Text: sp_MShelp_profile 2007-03-21 14:42:57.98 Parameters: 2007-03-21 14:42:57.98 @agent_id = 1 2007-03-21 14:42:57.98 @agent_type = 1 2007-03-21 14:42:57.98 @profile_name = 2007-03-21 14:42:57.98 Parameter values obtained from agent profile: 2007-03-21 14:42:57.98 --------------------------------------------- 2007-03-21 14:42:57.98 -BcpBatchSize 100000 2007-03-21 14:42:57.98 -HistoryVerboseLevel 2 2007-03-21 14:42:57.98 -LoginTimeout 15 2007-03-21 14:42:57.98 -QueryTimeout 1800 2007-03-21 14:42:57.98 --------------------------------------------- 2007-03-21 14:42:58.00 Connecting to Publisher 'NOMOS-SRVR' 2007-03-21 14:42:58.03 2007-03-21 14:42:58.03 SQL Command dump 2007-03-21 14:42:58.03 ================ 2007-03-21 14:42:58.03 Server: NOMOS-SRVR 2007-03-21 14:42:58.03 Database: TEST 2007-03-21 14:42:58.03 Command Text: use master 2007-03-21 14:42:58.03 select isnull(convert(int, value_in_use), 0) from master.sys.configurations where lower(name) = 'smo and dmo xps' 2007-03-21 14:42:58.03 use [TEST] 2007-03-21 14:42:58.03 Parameters: 2007-03-21 14:42:58.04 2007-03-21 14:42:58.04 SQL Command dump 2007-03-21 14:42:58.04 ================ 2007-03-21 14:42:58.04 Server: NOMOS-SRVR 2007-03-21 14:42:58.04 Database: TEST 2007-03-21 14:42:58.04 Command Text: use [TEST] 2007-03-21 14:42:58.04 select publishingservername(), convert(int, compatibility_level) from sys.databases where name = @database_name 2007-03-21 14:42:58.04 Parameters: 2007-03-21 14:42:58.04 @database_name = TEST 2007-03-21 14:42:58.04 Publisher database compatibility level is set to 80. 2007-03-21 14:42:58.04 2007-03-21 14:42:58.04 SQL Command dump 2007-03-21 14:42:58.04 ================ 2007-03-21 14:42:58.04 Server: NOMOS-SRVR 2007-03-21 14:42:58.04 Database: TEST 2007-03-21 14:42:58.04 Command Text: select convert(int, isnull(is_member('db_owner'),0)) 2007-03-21 14:42:58.04 Parameters: 2007-03-21 14:42:58.04 2007-03-21 14:42:58.04 SQL Command dump 2007-03-21 14:42:58.04 ================ 2007-03-21 14:42:58.04 Server: NOMOS-SRVR 2007-03-21 14:42:58.04 Database: TEST 2007-03-21 14:42:58.04 Command Text: 2007-03-21 14:42:58.04 declare @retcode int 2007-03-21 14:42:58.04 exec @retcode = sys.sp_getapplock @Resource = N'NOMOS-SRVR-TEST-TestPublication-1', 2007-03-21 14:42:58.04 @LockMode = N'Exclusive', 2007-03-21 14:42:58.04 @LockOwner = N'Session', 2007-03-21 14:42:58.04 @LockTimeout = 0, 2007-03-21 14:42:58.04 @DbPrincipal = N'db_owner' 2007-03-21 14:42:58.04 if @retcode < 0 raiserror(21036, 16, -1, 'snapshot') 2007-03-21 14:42:58.04 Parameters: 2007-03-21 14:42:58.04 Retrieving publication and article information from the publisher database 'NOMOS-SRVR.TEST' 2007-03-21 14:42:58.04 2007-03-21 14:42:58.04 SQL Command dump 2007-03-21 14:42:58.04 ================ 2007-03-21 14:42:58.04 Server: NOMOS-SRVR 2007-03-21 14:42:58.04 Database: TEST 2007-03-21 14:42:58.04 Command Text: sp_helppublication 2007-03-21 14:42:58.04 Parameters: 2007-03-21 14:42:58.04 @publication = TestPublication 2007-03-21 14:42:58.04 2007-03-21 14:42:58.04 SQL Command dump 2007-03-21 14:42:58.04 ================ 2007-03-21 14:42:58.04 Server: NOMOS-SRVR 2007-03-21 14:42:58.04 Database: TEST 2007-03-21 14:42:58.04 Command Text: if object_id('sys.sp_checkinvalidivarticle') < 0 exec sp_checkinvalidivarticle @mode, @publication 2007-03-21 14:42:58.04 Parameters: 2007-03-21 14:42:58.04 @mode = 1 2007-03-21 14:42:58.04 @publication = TestPublication 2007-03-21 14:42:58.04 2007-03-21 14:42:58.04 SQL Command dump 2007-03-21 14:42:58.04 ================ 2007-03-21 14:42:58.04 Server: NOMOS-SRVR 2007-03-21 14:42:58.04 Database: TEST 2007-03-21 14:42:58.04 Command Text: declare @ftp_password nvarchar(524) select @ftp_password = ftp_password from dbo.syspublications where name =
Here is is the next part of the file :
================================ 2007-03-21 14:43:00.00 Parameters: 2007-03-21 14:43:00.00 @publisher_id = 0 2007-03-21 14:43:00.00 @publisher_db = TEST 2007-03-21 14:43:00.00 @type = -2147483546 2007-03-21 14:43:00.00 @article_id = 1 2007-03-21 14:43:00.00 @xact_id = System.Byte[] 2007-03-21 14:43:00.00 @xact_seqno = SqlBinary(14) 2007-03-21 14:43:00.00 @command_id = 6 2007-03-21 14:43:00.00 @partial_command = False 2007-03-21 14:43:00.00 @command = System.Byte[] 2007-03-21 14:43:00.00 2007-03-21 14:43:00.00 SQL Command dump 2007-03-21 14:43:00.00 ================ 2007-03-21 14:43:00.00 Server: NOMOS-SRVR 2007-03-21 14:43:00.00 Database: distribution 2007-03-21 14:43:00.00 Command Text: sp_MSadd_repl_command 2007-03-21 14:43:00.00 Parameters: 2007-03-21 14:43:00.00 @publisher_id = 0 2007-03-21 14:43:00.00 @publisher_db = TEST 2007-03-21 14:43:00.00 @type = -2147483646 2007-03-21 14:43:00.00 @article_id = 1 2007-03-21 14:43:00.00 @xact_id = System.Byte[] 2007-03-21 14:43:00.00 @xact_seqno = SqlBinary(14) 2007-03-21 14:43:00.00 @command_id = 7 2007-03-21 14:43:00.00 @partial_command = False 2007-03-21 14:43:00.00 @command = System.Byte[] 2007-03-21 14:43:00.00 [61%] Inserted index creation command for article 'STATE' into the distribution database. 2007-03-21 14:43:00.00 2007-03-21 14:43:00.00 SQL Command dump 2007-03-21 14:43:00.00 ================ 2007-03-21 14:43:00.00 Server: NOMOS-SRVR 2007-03-21 14:43:00.00 Database: distribution 2007-03-21 14:43:00.00 Command Text: sp_MSadd_repl_command 2007-03-21 14:43:00.00 Parameters: 2007-03-21 14:43:00.00 @publisher_id = 0 2007-03-21 14:43:00.00 @publisher_db = TEST 2007-03-21 14:43:00.00 @type = -2147483645 2007-03-21 14:43:00.00 @article_id = 1 2007-03-21 14:43:00.00 @xact_id = System.Byte[] 2007-03-21 14:43:00.00 @xact_seqno = SqlBinary(14) 2007-03-21 14:43:00.00 @command_id = 8 2007-03-21 14:43:00.00 @partial_command = False 2007-03-21 14:43:00.00 @command = System.Byte[] 2007-03-21 14:43:00.00 [61%] Inserted bcp command for article 'STATE' into the distribution database. 2007-03-21 14:43:00.00 2007-03-21 14:43:00.00 SQL Command dump 2007-03-21 14:43:00.00 ================ 2007-03-21 14:43:00.00 Server: NOMOS-SRVR 2007-03-21 14:43:00.00 Database: TEST 2007-03-21 14:43:00.00 Command Text: sp_MSget_synctran_commands 2007-03-21 14:43:00.00 Parameters: 2007-03-21 14:43:00.00 @publication = TestPublication 2007-03-21 14:43:00.01 2007-03-21 14:43:00.01 SQL Command dump 2007-03-21 14:43:00.01 ================ 2007-03-21 14:43:00.01 Server: NOMOS-SRVR 2007-03-21 14:43:00.01 Database: distribution 2007-03-21 14:43:00.01 Command Text: sp_MSadd_repl_command 2007-03-21 14:43:00.01 Parameters: 2007-03-21 14:43:00.01 @publisher_id = 0 2007-03-21 14:43:00.01 @publisher_db = TEST 2007-03-21 14:43:00.01 @type = -2147483596 2007-03-21 14:43:00.01 @article_id = 1 2007-03-21 14:43:00.01 @xact_id = System.Byte[] 2007-03-21 14:43:00.01 @xact_seqno = SqlBinary(14) 2007-03-21 14:43:00.01 @command_id = 9 2007-03-21 14:43:00.01 @partial_command = False 2007-03-21 14:43:00.01 @command = System.Byte[] 2007-03-21 14:43:00.01 2007-03-21 14:43:00.01 SQL Command dump 2007-03-21 14:43:00.01 ================ 2007-03-21 14:43:00.01 Server: NOMOS-SRVR 2007-03-21 14:43:00.01 Database: distribution 2007-03-21 14:43:00.01 Command Text: sp_MSlock_auto_sub 2007-03-21 14:43:00.01 Parameters: 2007-03-21 14:43:00.01 @publisher_id = 0 2007-03-21 14:43:00.01 @publisher_db = TEST 2007-03-21 14:43:00.01 @publication = TestPublication 2007-03-21 14:43:00.01 @reset = 1 2007-03-21 14:43:00.01 2007-03-21 14:43:00.01 SQL Command dump 2007-03-21 14:43:00.01 ================ 2007-03-21 14:43:00.01 Server: NOMOS-SRVR 2007-03-21 14:43:00.01 Database: distribution 2007-03-21 14:43:00.01 Command Text: sp_MSset_snapshot_xact_seqno 2007-03-21 14:43:00.01 Parameters: 2007-03-21 14:43:00.01 @publisher_id = 0 2007-03-21 14:43:00.01 @publisher_db = TEST 2007-03-21 14:43:00.01 @article_id = 1 2007-03-21 14:43:00.01 @xact_seqno = SqlBinary(14) 2007-03-21 14:43:00.01 @reset = 1 2007-03-21 14:43:00.01 @publisher_seqno = SqlBinary(10) 2007-03-21 14:43:00.01 @ss_cplt_seqno = Null 2007-03-21 14:43:00.01 2007-03-21 14:43:00.01 SQL Command dump 2007-03-21 14:43:00.01 ================ 2007-03-21 14:43:00.01 Server: NOMOS-SRVR 2007-03-21 14:43:00.01 Database: distribution 2007-03-21 14:43:00.01 Command Text: sp_MSdist_activate_auto_sub 2007-03-21 14:43:00.01 Parameters: 2007-03-21 14:43:00.01 @publisher_id = 0 2007-03-21 14:43:00.01 @publisher_db = TEST 2007-03-21 14:43:00.01 @article_id = 1 2007-03-21 14:43:00.01 2007-03-21 14:43:00.01 SQL Command dump 2007-03-21 14:43:00.01 ================ 2007-03-21 14:43:00.01 Server: NOMOS-SRVR 2007-03-21 14:43:00.01 Database: distribution 2007-03-21 14:43:00.01 Command Text: COMMIT TRANSACTION 2007-03-21 14:43:00.01 Parameters: 2007-03-21 14:43:00.01 2007-03-21 14:43:00.01 SQL Command dump 2007-03-21 14:43:00.01 ================ 2007-03-21 14:43:00.01 Server: NOMOS-SRVR 2007-03-21 14:43:00.01 Database: TEST 2007-03-21 14:43:00.01 Command Text: COMMIT TRANSACTION 2007-03-21 14:43:00.01 Parameters: 2007-03-21 14:43:00.03 [100%] A snapshot of 1 article(s) was generated. 2007-03-21 14:43:00.03 *************************** Performance Statistics **************************** 2007-03-21 14:43:00.03 Overall snapshot generation time (seconds): 2,05 2007-03-21 14:43:00.03 Total number of rows bulk-copied from published objects: 4 2007-03-21 14:43:00.03 Time spent generating schema scripts (seconds): 1,59 2007-03-21 14:43:00.03 Time spent pre-loading database objects for scripting (seconds): 1,44 2007-03-21 14:43:00.03 Time spent analyzing article object dependencies (seconds): 0,05 2007-03-21 14:43:00.03 Time spent customizing article objects for scripting (seconds): 0,00 2007-03-21 14:43:00.03 Time spent resolving duplicate object names (seconds): 0,00 2007-03-21 14:43:00.03 Time spent analyzing foreign key references (seconds): 0,00 2007-03-21 14:43:00.03 Time spent analyzing check and default constraint references (seconds): 0,00 2007-03-21 14:43:00.03 Time spent analyzing non-article object dependencies (seconds): 0,00 2007-03-21 14:43:00.03 Time spent preparing snapshot generation (seconds): 0,11 2007-03-21 14:43:00.03 Time spent bulk copying data (seconds): 0,09 2007-03-21 14:43:00.03 Time spent copying/compressing generated file (seconds): 0,00 2007-03-21 14:43:00.03 Time spent posting snapshot commands (seconds): 0,06 2007-03-21 14:43:00.03 ******************************************************************************* 2007-03-21 14:43:00.04 2007-03-21 14:43:00.04 SQL Command dump 2007-03-21 14:43:00.04 ================ 2007-03-21 14:43:00.04 Server: NOMOS-SRVR
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |