Showing posts with label failure. Show all posts
Showing posts with label failure. Show all posts

Wednesday, March 28, 2012

How to determine what patches are needed to restore Master

I have had to rebuild our SQL server from scratch due to hardware failure.
Because of a version mismatch... this has presented a problem to me in
restoring the Master database. The previous admin did not leave notes on
what patches were installed on the server, and all that I know is SP1 was
installed minimum.
I have since installed SP1, but I seem to be missing a couple more patches.
Is there any way to determine what patches I need from the error message
given during restore? Current version: 134218112 Master Database
Version: 134218262
Thank you all in advance for your assistance.Was able to extract the actual software version information...
The current software version is: 8.00.384
The backup Master version is : 8.00.534

Wednesday, March 21, 2012

how to detect transactional replication agent failure programmatic

Hello,
Right now, I have an alert set up in the SQL Server but is it possible for a
C#/C/C++/VB program to detect the replication agent failure? If so, how can
it be done?
Thanks in advance,
Frank
query the repl_errors table in the distirbution database.
select name, Publisher=p.srvname, publisher_db, publication,
Subscriber=s.srvname, subscriber_db, MSdistribution_history.time, comments,
error_type_id,source_type_id, source_name, error_code,error_text from
MSdistribution_history
join msrepl_errors on MSdistribution_history.error_id=msrepl_errors.id
join msdistribution_agents on
msdistribution_agents.id=MSdistribution_history.ag ent_id
join master.dbo.sysservers as p on p.srvid=publisher_id
join master.dbo.sysservers as s on s.srvid=publisher_id
order by 1
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
"FJY" <FJY@.discussions.microsoft.com> wrote in message
news:1F219C21-2032-422F-AC54-C0D5BBC15CAA@.microsoft.com...
> Hello,
> Right now, I have an alert set up in the SQL Server but is it possible for
> a
> C#/C/C++/VB program to detect the replication agent failure? If so, how
> can
> it be done?
> Thanks in advance,
> Frank