| Author |
Topic |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2008-10-30 : 08:50:34
|
| Hello everyone,I need to setup a server that will act as a reporting data server.What type of data 'movement' should i go with?Problems...1) Mirroring will not allow clients to query data on thereporting server2) Backup and restore poses a huge load on the production serversWhat are my options to allow clients to query data on the report server AND keep the data from production onto the report database semi-sync'dthanks in advancetake caretony |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-30 : 08:52:22
|
| Transactional Replication. |
 |
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2008-10-30 : 09:36:11
|
| Thanks for the direction....The production servers do not have replication installed.I tried to install the replication, but it fails. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-30 : 12:03:06
|
| Replication comes with SQL Server. What edition is it? |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-30 : 23:03:25
|
| Evaluate your needs before jumping to any conclusion. All three have pros/cons so first look at your SLA for reporting users. Do some research on all of them. see if this helps youhttp://technet.microsoft.com/en-us/magazine/cc160992.aspx |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-30 : 23:10:58
|
quote:
Originally posted by saurabhsrivastava
Evaluate your needs before jumping to any conclusion. All three have pros/cons so first look at your SLA for reporting users. Do some research on all of them. see if this helps youhttp://technet.microsoft.com/en-us/magazine/cc160992.aspx
What do you see disadvantages of Transactional Replication for Reporting Needs? |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2008-10-31 : 05:48:55
|
| Thats not the issue anymore - Replication fails to load on the enterprise version of SQL server 2005... all of them in production (~20 servers)I think they were replicated from a single installation across all the VM's and since the first one was effd,then all of them are effd. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-01 : 12:34:59
|
| Isn't there Replication tab in Object explorer? Or can you explain clearly? |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-11-03 : 23:33:17
|
Its not about disadvantage or benefits. We are giving options because we don't know his enviornment and business needs. So it is always better to do some research before implementing any solution. There are many ways to implement a reporting solution and each has its pros/cons and one should go in details prior to taking any further steps. I hope that make sense quote:
Originally posted by sodeep
quote:
Originally posted by saurabhsrivastava
Evaluate your needs before jumping to any conclusion. All three have pros/cons so first look at your SLA for reporting users. Do some research on all of them. see if this helps youhttp://technet.microsoft.com/en-us/magazine/cc160992.aspx
What do you see disadvantages of Transactional Replication for Reporting Needs?
|
|
|
|
|
Mirror, t-log shipping or what??