Category Archives: Add/remove

Re-initialize replication not working

For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask for- do you want to generate snapshot now, if you say “yes” it will create a metadata of the articles … Continue reading

Posted in Add/remove, High Avaliability, Replication, Troubleshooting | 1 Comment

Sql Cluster Resource not comming online

when you check on the sql server services and sql agent services it’s getting started on windows cluster but on cluster its going down again. on error log you may get the cluster service Login failed for user ‘cluster service … Continue reading

Posted in Add/remove, Bug, Disaster Recovery, Error Log, High Avaliability | Tagged , , , , | Leave a comment

Denali – Day 14: New DMV & DMF

Denali – Day 14: New DMV & DMF   As there has been so many DMV/DMF already introduced in earlier version of Sql server, Denali does not have much on this part, but 5 new dmv/dmf and 1 modified here … Continue reading

Posted in Add/remove, Denali, DMV, Whats New | Tagged , | Leave a comment

Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration

Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration   I know this should be first or second blog post when you blog on any new technology, but as I said, I write as it goes. … Continue reading

Posted in Add/remove, Denali, Installation | Tagged , | Leave a comment

Desktop Edition Sql server 2000 MSDE Install upgrade

for sql server 2000 (I know its old) desktop edition does not includes any GUI. so installation of desktop edition ie MSDE is via command prompt. you can install the setup for desktop edition for free from here. http://www.microsoft.com/download/en/details.aspx?id=22661 to … Continue reading

Posted in Add/remove, Installation, Limitation, Troubleshooting | Tagged , , | Leave a comment

Dynamic Add/Remove file in Mirroring/Logshipping

Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether can we dynamically add/drop any new file in our principle or primary database, got conclusion that YES it is … Continue reading

Posted in Add/remove, Disaster Recovery, High Avaliability | Tagged , | Leave a comment

spid in Killed/Rollback cannot kill – external

We come across a situation where we have to kill one spid which was running for quite some time, so we though killing will help us, but after killing found that that spid is not killed but stuck in our … Continue reading

Posted in Add/remove, Lock/Blocking, Others | Tagged , , | Leave a comment

unistall sql server completely (Must Read)

Everyone know how to uninstall sql server very easy : control panel -<Add remove programs ->sql server some times you can also uninstall using setup cd/setup dump. found a very great forum answer which shows how to unistall sql server … Continue reading

Posted in Add/remove, General, Installation, Software, Tool, What I learned today | Tagged | Leave a comment

Adding Articles to and Dropping Articles from Existing Publications

While checking on the forum found many questions about how to add/drop articles from existing replication. so though of blogging on it. Everyone should follow this (must read) which is the base/reference for this blog . >>Snapshot/Transactional Replicaiton:- Adding Articles:- … Continue reading

Posted in Add/remove, Replication | Tagged | Leave a comment