Reporting Server.

Hi,
We are using a live database and want to set up a Reporting Server(Read-Only
for Users) for processing queries.
Is there any 3rd party software producing the effect
of Transactional Replication, being easy to set up and maintain ?
Any links to good step by step guides for Transactional Replication will
also be appreciated. I suspect it's a difficult job to set up and maintain
Transactional Replication, but I may give it a try.
Regards.
SezginHi
You may want to use replication if you don't want medium/high latency on
updating your data, but if you can copy with a longer difference between the
data in your reporting database and the live system check out log shipping.
There was a couple of articles on this in SQL Server Professional Magazine
http://tinyurl.com/4ez3l
http://tinyurl.com/6rdth
You may also want to check out the simple log shipping solution in the
resource kit.
John
"Sezgin Rafet" wrote:
> Hi,
> We are using a live database and want to set up a Reporting Server(Read-Only
> for Users) for processing queries.
> Is there any 3rd party software producing the effect
> of Transactional Replication, being easy to set up and maintain ?
> Any links to good step by step guides for Transactional Replication will
> also be appreciated. I suspect it's a difficult job to set up and maintain
> Transactional Replication, but I may give it a try.
>
> Regards.
> Sezgin
>
>|||Thanks for the reply.
I did a short research on the Internet.
3 products attracted my attention:
DoubleTake from NSI Software
SonaSafe for SQL Server from Sonasoft
WANSync / WANSyncHA from XOsoft
Any comments on these products from people who have used them will be
appreciated.
Regards.
Sezgin
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...
> Hi
> You may want to use replication if you don't want medium/high latency on
> updating your data, but if you can copy with a longer difference between
> the
> data in your reporting database and the live system check out log
> shipping.
> There was a couple of articles on this in SQL Server Professional Magazine
> http://tinyurl.com/4ez3l
> http://tinyurl.com/6rdth
> You may also want to check out the simple log shipping solution in the
> resource kit.
> John
> "Sezgin Rafet" wrote:
>> Hi,
>> We are using a live database and want to set up a Reporting
>> Server(Read-Only
>> for Users) for processing queries.
>> Is there any 3rd party software producing the effect
>> of Transactional Replication, being easy to set up and maintain ?
>> Any links to good step by step guides for Transactional Replication will
>> also be appreciated. I suspect it's a difficult job to set up and
>> maintain
>> Transactional Replication, but I may give it a try.
>>
>> Regards.
>> Sezgin
>>|||You should also look at Neverfail (www.neverfailgroup.com) I used this
in a previous company and seemed to work for us for SQL and their
Exchange product kicks A**
Pete
Sezgin Rafet wrote:
> Thanks for the reply.
> I did a short research on the Internet.
> 3 products attracted my attention:
> DoubleTake from NSI Software
> SonaSafe for SQL Server from Sonasoft
> WANSync / WANSyncHA from XOsoft
>
> Any comments on these products from people who have used them will be
> appreciated.
>
> Regards.
> Sezgin
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...
> > Hi
> >
> > You may want to use replication if you don't want medium/high latency on
> > updating your data, but if you can copy with a longer difference between
> > the
> > data in your reporting database and the live system check out log
> > shipping.
> >
> > There was a couple of articles on this in SQL Server Professional Magazine
> > http://tinyurl.com/4ez3l
> > http://tinyurl.com/6rdth
> >
> > You may also want to check out the simple log shipping solution in the
> > resource kit.
> >
> > John
> >
> > "Sezgin Rafet" wrote:
> >
> >>
> >> Hi,
> >>
> >> We are using a live database and want to set up a Reporting
> >> Server(Read-Only
> >> for Users) for processing queries.
> >>
> >> Is there any 3rd party software producing the effect
> >> of Transactional Replication, being easy to set up and maintain ?
> >>
> >> Any links to good step by step guides for Transactional Replication will
> >> also be appreciated. I suspect it's a difficult job to set up and
> >> maintain
> >> Transactional Replication, but I may give it a try.
> >>
> >>
> >> Regards.
> >>
> >> Sezgin
> >>
> >>
> >>|||Hi
I have not tried any of the third party applications but the no cost option
would be to use what is in the Resource Kit or use the method described by
SQL Server Pro. With SQL 2005 you will get database mirroring.
John
"Sezgin Rafet" wrote:
> Thanks for the reply.
> I did a short research on the Internet.
> 3 products attracted my attention:
> DoubleTake from NSI Software
> SonaSafe for SQL Server from Sonasoft
> WANSync / WANSyncHA from XOsoft
>
> Any comments on these products from people who have used them will be
> appreciated.
>
> Regards.
> Sezgin
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...
> > Hi
> >
> > You may want to use replication if you don't want medium/high latency on
> > updating your data, but if you can copy with a longer difference between
> > the
> > data in your reporting database and the live system check out log
> > shipping.
> >
> > There was a couple of articles on this in SQL Server Professional Magazine
> > http://tinyurl.com/4ez3l
> > http://tinyurl.com/6rdth
> >
> > You may also want to check out the simple log shipping solution in the
> > resource kit.
> >
> > John
> >
> > "Sezgin Rafet" wrote:
> >
> >>
> >> Hi,
> >>
> >> We are using a live database and want to set up a Reporting
> >> Server(Read-Only
> >> for Users) for processing queries.
> >>
> >> Is there any 3rd party software producing the effect
> >> of Transactional Replication, being easy to set up and maintain ?
> >>
> >> Any links to good step by step guides for Transactional Replication will
> >> also be appreciated. I suspect it's a difficult job to set up and
> >> maintain
> >> Transactional Replication, but I may give it a try.
> >>
> >>
> >> Regards.
> >>
> >> Sezgin
> >>
> >>
> >>
>
>