May 30, 2008 at 3:41 pm
HI ALL , one guy ask me in interview for sql dba post.
que1: What are the Status of database when you got some problem( quit)during upgradation from sql server 2005 sp1 to sql server SP2????
If you 'll get problems then wht 'll you do with installation? means you install again SP2? or if you want to keep sp1 then wht 'll you do?( are you REinstall SP1 for same situation)
plz help me out with this question
que 2:-- you have 10 tables as Articles in Tran Replication, if some one drop 1 table from Publisher (which is part of Articles) so wts are the circumtances come across ?
---> it 'll stop replicating that table or we have to create/define that table as new article in replication????/
plz help me out guys
May 30, 2008 at 3:48 pm
1. You can reapply sp2 if neccessary...
if you want to go back to sp1 follow the readme file instructions...
2. You can't drop the table when it is participating in replication without removing from publication.
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply