The subject line pretty much says it all. I'be been trying to use the SQL
Enterprise Administrator that came with SQL 2000 Enterprise to configure log
shipping, but the checkbox does not appear for databases on my MSDE servers,
only for the databases on my SQL 2000 Standard servers. Is there a way to set
up log shipping with MSDE?
--EricYes and no.
Log shipping is built in to Enterprise Edition only. However, there is
nothing preventing you from writing your own or using a third-party Log
Shipping solution with MSDE. The SQL 2000 Resource Kit even has an example.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Eric Robinson" <eric@._nospam_nvipa.com> wrote in message
news:CFN379450764603357@.news.microsoft.com...
> The subject line pretty much says it all. I'be been trying to use the SQL
> Enterprise Administrator that came with SQL 2000 Enterprise to configure
log
> shipping, but the checkbox does not appear for databases on my MSDE
servers,
> only for the databases on my SQL 2000 Standard servers. Is there a way to
set
> up log shipping with MSDE?
> --Eric|||To expand on Geoff's post, here is a site that you may find helpful:
http://sqlguy.home.comcast.net/logship.htm
-- Keith
"Eric Robinson" <eric@._nospam_nvipa.com> wrote in message =news:CFN379450764603357@.news.microsoft.com...
> The subject line pretty much says it all. I'be been trying to use the =SQL > Enterprise Administrator that came with SQL 2000 Enterprise to =configure log > shipping, but the checkbox does not appear for databases on my MSDE =servers, > only for the databases on my SQL 2000 Standard servers. Is there a way =to set > up log shipping with MSDE?
> > --Eric
Showing posts with label subject. Show all posts
Showing posts with label subject. Show all posts
Monday, March 19, 2012
Can MSDE Do Log Shipping?
Thursday, February 16, 2012
Can I run Report Engine and Report Manager in different servers?
The Subject is the whole question: Can I run Report Engine and Report Manager
in different servers?
This is because of my current network infra-strucutre.. I know that
ReportServer is a Web-Service and Report Manager is a Web Application that
consumes this Web-Service, so I would like to know how can I configure this
App to run in another server and access the remote web service.
Thx,
Rafa®AFAIK, the only splitting of the features can be done by dividing the
database and the ReportServer (Web and Service). Nethertheless, if you could
divide them you would need two licences of SQL Server either. So building of
two ReportServers which can be connected to only one Reporting Database is
possible on by design. See SQL Server Reporting Secifications for more
Details.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Rafa®" <Rafa@.discussions.microsoft.com> schrieb im Newsbeitrag
news:1DC7543E-F51B-4F53-BC0E-8D323B635967@.microsoft.com...
> The Subject is the whole question: Can I run Report Engine and Report
> Manager
> in different servers?
> This is because of my current network infra-strucutre.. I know that
> ReportServer is a Web-Service and Report Manager is a Web Application that
> consumes this Web-Service, so I would like to know how can I configure
> this
> App to run in another server and access the remote web service.
> Thx,
> Rafa®
in different servers?
This is because of my current network infra-strucutre.. I know that
ReportServer is a Web-Service and Report Manager is a Web Application that
consumes this Web-Service, so I would like to know how can I configure this
App to run in another server and access the remote web service.
Thx,
Rafa®AFAIK, the only splitting of the features can be done by dividing the
database and the ReportServer (Web and Service). Nethertheless, if you could
divide them you would need two licences of SQL Server either. So building of
two ReportServers which can be connected to only one Reporting Database is
possible on by design. See SQL Server Reporting Secifications for more
Details.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Rafa®" <Rafa@.discussions.microsoft.com> schrieb im Newsbeitrag
news:1DC7543E-F51B-4F53-BC0E-8D323B635967@.microsoft.com...
> The Subject is the whole question: Can I run Report Engine and Report
> Manager
> in different servers?
> This is because of my current network infra-strucutre.. I know that
> ReportServer is a Web-Service and Report Manager is a Web Application that
> consumes this Web-Service, so I would like to know how can I configure
> this
> App to run in another server and access the remote web service.
> Thx,
> Rafa®
Subscribe to:
Posts (Atom)