asked
SQL DBA Questions
Hi, 1. For 10GB database Which one is the best(LS or replication)? 2. In LOGSHIPPING how do u identify how many secondary servers are there? 3. How to select the rows in replication? 4. How to add articles for already existing replication? 5. what lock will be occur in snapshot replication? 6. Diff b/w serilizable and snapshot isolations Any explanation is highly appreciated !!!!! Thanking You
In general, answering homework questions is frowned on unless you show us work you've done. We'll help, absolutely, but since it's your grade, not ours, we usually want to see that you're attempting to learn, not just scam an answer from the intertubes.
Recommended reading: 1. Best for what? They aren't mutually exclusive and the answer could be highly subjective. For protecting data, MS comes right out and recommends specific features here - [
http://msdn.microsoft.com/en-us/library/ms190202.aspx][1] 2. [
http://msdn.microsoft.com/en-us/library/ms175106.aspx][2] 3. Which rows? `select * from replicated_table` ? 4. [
http://msdn.microsoft.com/en-us/library/ms152493.aspx][3] 5. [
http://msdn.microsoft.com/en-us/library/aa256290(v=sql.80).aspx][4] 6. [
http://msdn.microsoft.com/en-us/library/ms173763(v=sql.105).aspx][5] [1]:
http://msdn.microsoft.com/en-us/library/ms190202.aspx [2]:
http://msdn.microsoft.com/en-us/library/ms175106.aspx [3]:
http://msdn.microsoft.com/en-us/library/ms152493.aspx [4]:
http://msdn.microsoft.com/en-us/library/aa256290(v=sql.80).aspx [5]:
http://msdn.microsoft.com/en-us/library/ms173763(v=sql.105).aspx
Concerning Q1 - the size of the database is largely irrelevant, what is important is the amount of transactions taking place in any given time period. Along with how the primary and secondary servers are connected and so on. For all points I can only recommend the links that @KenJ has provided. Research. Learn. Get good grades. ;)
17 People are following this question.
