Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql2005dba
Starting Member
8 Posts |
 Posted - 2010-08-03 : 14:11:51
|
| We have three SQL SERVER 2005 servers A, B, C . Server A has a database db1 which is principal for db1 on Server B (Mirroring is going on between Server A and Server B)). On server B , we have a database snapshot of db1 mirror for reporting purposes. Now for more reporting purposes, we need a real time copy of database db1 on Server C . What is the best possible way to do it. I am not able to figure out if that is even possible.Please Help !! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-08-03 : 14:22:05
|
| You can use transactional replication for this. We have a similar setup as yours. We use the database snapshot off the mirror so that internal folks can query data without impacting production. We use the replicated database for our users' reporting needs. So we've got mirroring + database snapshot off the mirror + transactional replication. We've also got clustering. It gets quite confusing sometimes, so that's where a system diagram helps.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
sql2005dba
Starting Member
8 Posts |
Posted - 2010-08-05 : 09:31:14
|
| Thanks a lot . I will try to establish that.Can we use server B (on which we have mirror and snapshot)in any way to produce another copy of the database for server C ?? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-05 : 09:47:06
|
| Hm, that's actually quite interesting...so you want to have transactional replication with the snapshot as a source, is that right?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-05 : 09:51:18
|
| Hmm...after thinking a bit that doesn't make any sense does it...? Because the snapshot is of course just a view of the data at a certain point in time, it doesn't get updated. Without knowing or having read anything about it my reasoning tells me it would be impossible and that you would have to use server A as the source for server C as well.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
sql2005dba
Starting Member
8 Posts |
Posted - 2010-08-05 : 10:03:22
|
| Thanks Lumbago..My common sense tells me that too. But I just don't want to miss any point here . Because using server A as the source is raising some objections among my user base due to performance concerns [It is already a Principal for mirroring , Adding replication can add up logs to be sent and cause performance hit??]. Strangely I cannot find anything related to this online. The only solution as suggested by Tara seemas to be possible. I hoped there was something that could be done off server B ! Some workaround or something ! |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-05 : 12:06:47
|
| http://msdn.microsoft.com/en-us/library/ms151799.aspx |
|
|
|
|
|
|
|
|
Mirroring , DB Snapshot ,Replication together?