Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: December 2009

Error Log:

Following steps happened when sql server starts… we can see that in error log::

1. Build of sql server and platform as Microsoft Sql server 2005 version. Edition on OS.

2. Windows process ID (kid):

3. Error log file location.

4. when last time sql was down and what spid…

Read more

0 comments, 278 reads

Posted in Vinay Thakur on 25 December 2009

Remove Replication:

Its quite some time that I blog… but good news is I have some good stuff to blog on… so could be you will see some good blog in pipeline soon.

I blog on how to configure the replication here with commands and a separate blog for replication setup here Read more

0 comments, 1,782 reads

Posted in Vinay Thakur on 16 December 2009

Transactional Replication Conversations –Must read

Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must read a great blog :

http://blogs.msdn.com/chrissk/archive/2009/05/25/transactional-replication-conversations.aspx

Summary:

log reader read the transactions(Changes) with sp_replcmds, for xp_replcmds.

then log reader writes into distributor database using sp_MSadd_replcmds

Distributor reads commands using sp_MSget_repl_commands… Read more

0 comments, 985 reads

Posted in Vinay Thakur on 3 December 2009