Showing posts with label determine. Show all posts
Showing posts with label determine. Show all posts

Wednesday, March 28, 2012

Replication status check

What is the best way to determine if transactional replication is alive and
well? I would like to know if the snapshots are completed, the articles are
being published, and that replicated transactions are being processed by the
subscriber.
Bob b
run sp_MSenum_snapshot
look for a status of 2, which means complete.
to check that replicated commands are being processed issue the below
select * from distribution.dbo.msdistribution_status
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
"bob b" <bobb@.discussions.microsoft.com> wrote in message
news:677477A8-E644-439A-BE90-96B1D94E0B14@.microsoft.com...
> What is the best way to determine if transactional replication is alive
and
> well? I would like to know if the snapshots are completed, the articles
are
> being published, and that replicated transactions are being processed by
the
> subscriber.
> --
> Bob b

Monday, March 26, 2012

replication related questions

I have a couple questions about replication (for both 2000 and 2005 servers):

1. which system tables/dmvs/system sprocs can I look at to determine which columns of a table are being replicated?

2. which system tables/dmvs/sprocs can I call to get metadata about publishers and subscribers?

Thanks!1. None of them, since Microsoft changes the table structures and internal details from time to time, and emphatically does NOT guarantee anything about those tables. The sp_helparticlecolumns (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl2_1d6b.asp) stored procedure will give you this information though, in a supported fashion too!

2. Again, none, for the same reason. There are more choices for stored procedures here, can you give an example of what information you're trying to retrieve?

-PatP|||I think I need to do some reading myself first.

These questions are actually straight from a customer of mine who wants me to add documentation of replication related stuff to sqlspec. I've never used replication before so I thought I'd ask here. Premature.

thanks though. I'll come back when I have done my homework!

Saturday, February 25, 2012

Replication latency

Hi,
I have set up a transactional replication on two SQL Server
2000 (SP3) machines.
How do I determine the time it passes between the
transaction was placed in the transaction log at the
Publisher and it has finished at the Subscriber?
--
Many thanks,
OskRun performance monitor... YOu should notice that there will now be new
counters for replication, one of which is latency...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Osk" <anonymous@.discussions.microsoft.com> wrote in message
news:2aa901c509c4$9d8b76d0$a501280a@.phx.gbl...
> Hi,
> I have set up a transactional replication on two SQL Server
> 2000 (SP3) machines.
> How do I determine the time it passes between the
> transaction was placed in the transaction log at the
> Publisher and it has finished at the Subscriber?
> --
> Many thanks,
> Osk

Replication latency

Hi,
I have set up a transactional replication on two SQL Server
2000 (SP3) machines.
How do I determine the time it passes between the
transaction was placed in the transaction log at the
Publisher and it has finished at the Subscriber?
Many thanks,
Osk
Run performance monitor... YOu should notice that there will now be new
counters for replication, one of which is latency...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Osk" <anonymous@.discussions.microsoft.com> wrote in message
news:2aa901c509c4$9d8b76d0$a501280a@.phx.gbl...
> Hi,
> I have set up a transactional replication on two SQL Server
> 2000 (SP3) machines.
> How do I determine the time it passes between the
> transaction was placed in the transaction log at the
> Publisher and it has finished at the Subscriber?
> --
> Many thanks,
> Osk

Replication latency

Hi,
I have set up a transactional replication on two SQL Server
2000 (SP3) machines.
How do I determine the time it passes between the
transaction was placed in the transaction log at the
Publisher and it has finished at the Subscriber?
Many thanks,
OskRun performance monitor... YOu should notice that there will now be new
counters for replication, one of which is latency...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Osk" <anonymous@.discussions.microsoft.com> wrote in message
news:2aa901c509c4$9d8b76d0$a501280a@.phx.gbl...
> Hi,
> I have set up a transactional replication on two SQL Server
> 2000 (SP3) machines.
> How do I determine the time it passes between the
> transaction was placed in the transaction log at the
> Publisher and it has finished at the Subscriber?
> --
> Many thanks,
> Osk

Replication Job Failed. Unable to determine the owner

A former employee at my organization created a replication job to back up our database. The developer has since left and his windows account was deleted. I'm now receiving this error:

SQL Server Scheduled Job 'Replication agents checkup' (0xFC17DD4EF8E5694E8B786EE54CF8AD0D) - Status: Failed - Invoked on: 2007-06-05 15:40:00 - Message: The job failed. Unable to determine if the owner (username) of job Replication agents checkup has server access (reason: Could not obtain information about Windows NT group/user 'username', error code 0x534. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).

How can I fix this? I looked under the Replication folder but didn't see anything.

In Object Explorer, look at the job in SQL Server Agent to see who owns it, and verify the account is valid.

|||That's for the help. I changed the owner but am now getting this error:

SQL Server Scheduled Job 'Replication agents checkup' (0xFC17DD4EF8E5694E8B786EE54CF8AD0D) - Status: Failed - Invoked on: 2007-06-07 01:00:00 - Message: The job failed. The Job was invoked by Schedule 175 (Replication agent schedule.). The last step to run was step 1 (Run agent.).

When I executed the maintenance plan manually it worked, but it doesn't seem to work on the schedule. I've never created a maintenance plans so I'm going to look up some more information to see if I can figure out what is going to wrong.

Replication Job Failed. Unable to determine the owner

A former employee at my organization created a replication job to back up our database. The developer has since left and his windows account was deleted. I'm now receiving this error:

SQL Server Scheduled Job 'Replication agents checkup' (0xFC17DD4EF8E5694E8B786EE54CF8AD0D) - Status: Failed - Invoked on: 2007-06-05 15:40:00 - Message: The job failed. Unable to determine if the owner (username) of job Replication agents checkup has server access (reason: Could not obtain information about Windows NT group/user 'username', error code 0x534. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).

How can I fix this? I looked under the Replication folder but didn't see anything.

In Object Explorer, look at the job in SQL Server Agent to see who owns it, and verify the account is valid.

|||That's for the help. I changed the owner but am now getting this error:

SQL Server Scheduled Job 'Replication agents checkup' (0xFC17DD4EF8E5694E8B786EE54CF8AD0D) - Status: Failed - Invoked on: 2007-06-07 01:00:00 - Message: The job failed. The Job was invoked by Schedule 175 (Replication agent schedule.). The last step to run was step 1 (Run agent.).

When I executed the maintenance plan manually it worked, but it doesn't seem to work on the schedule. I've never created a maintenance plans so I'm going to look up some more information to see if I can figure out what is going to wrong.