May 8, 2011 at 7:04 am
In one of my interview, interviewer ask me about differential backup I described him differential backup ten again he asked me that how SQL Server knows which modified pages have been backed up and which page has to be backed up.
And another question is : If there is transactional replication, if new column is added on some table how this column will be replicated, do we need to do something on subscriber ? or will this be replicated automatically ?
May 8, 2011 at 8:11 am
Re the diff backup, google DCM (differential change map)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 9, 2011 at 1:38 am
Hi Gila,
DCM nice post, thank you.
Cheers!!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 9, 2011 at 9:32 am
Thanks for DCM it really helped.
May 10, 2011 at 12:10 am
i can't understood the answer properly.Can any one explain briefly ?
May 10, 2011 at 2:17 am
Go to your favourite search engine. Search for DCM or "Differential Change Map"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 10, 2011 at 8:22 am
RE: The Transactional Replication.
I recommend reading Books Online (or going to MSDN and searching Replication). Transactional Replication is a tricky beast and knowing the answer to just one question won't help you with your interviews. Because if you answer that question correctly, they'll be asking you more complicated questions to ascertain the depth of your knowledge.
May 10, 2011 at 11:16 am
Gail, I want to thank you for that search term. I learned a few things I didn't know.
May 10, 2011 at 11:28 am
Brandie Tarvin (5/10/2011)
Gail, I want to thank you for that search term. I learned a few things I didn't know.
Cool. Here's a couple more if you're bored and curious.
ML (minimally logged change map, also sometimes called BCM)
GAM
SGAM
IAM
PFS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 10, 2011 at 11:30 am
GilaMonster (5/10/2011)
Brandie Tarvin (5/10/2011)
Gail, I want to thank you for that search term. I learned a few things I didn't know.Cool. Here's a couple more if you're bored and curious.
ML (minimally logged change map, also sometimes called BCM)
GAM
SGAM
IAM
PFS
I caught the BCM, GAM, and SGAM in the very first link I visited. I'll need to check out the other two, though, because I didn't see anything about them.
May 10, 2011 at 11:43 am
Brandie Tarvin (5/10/2011)
I caught the BCM, GAM, and SGAM in the very first link I visited. I'll need to check out the other two, though, because I didn't see anything about them.
Index Allocation Map. Page Free Space.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 11, 2011 at 3:28 pm
In SQL Server 2000 if you add a column to a table you must add the column in the subscriber and add the column in the publication. In SQL Server 2005 and 2008 there is an option called Replicate Schema Changes, which gives you the option to replicate the ddl changes to the subscribers.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply