question

Manvendra avatar image
Manvendra 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
sql-server-2008sql-serverhomework
5 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Homework !!
1 Like 1 ·
At least you're honest about it! :-)
1 Like 1 ·
Interview? Homework?
0 Likes 0 ·
but anyway i didn't get my any answer :)
0 Likes 0 ·
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.
0 Likes 0 ·
KenJ avatar image
KenJ answered
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
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. ;)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.