Yeah, its Progress OpenEdge.
----- Original Message -----
From: Jeff Steward
To: NT System Admin Issues
Sent: Wednesday, October 20, 2010 12:41 PM
Subject: Re: Quick SQL Question
Wow - I'm not the only person using a Progress database!
-Jeff Steward
On Wed, Oct 20, 2010 at 12:35 PM, James Kerr <cluster...@gmail.com> wrote:
Of course, the report database is going to be generated from the production
database in the evenings. The production database isn't even SQL, it's Progress
and will be on its own hardware. I want to run the report database on the same
server that has SQL for our dental practice management.
James
----- Original Message -----
From: Ziots, Edward
To: NT System Admin Issues
Sent: Wednesday, October 20, 2010 12:19 PM
Subject: RE: Quick SQL Question
+1,
If you got the horse power then running SQL reporting services on the
same box as the SQL Server actually saves you in licensing costs and hardware
costs.
Although on the other hand I have never been a fan of doing reporting
against production databases, I rather see them Transactionally log shipped to
a dedicated SQL Server, and the reporting services either running on that
server, so the reports can be done, or this backup server is a dedicated
failover ( SQL 2005/2008 Mirrioring)
Z
Edward E. Ziots
CISSP, Network +, Security +
Network Engineer
Lifespan Organization
Email:ezi...@lifespan.org
Cell:401-639-3505
From: Don Ely [mailto:don....@gmail.com]
Sent: Wednesday, October 20, 2010 10:43 AM
To: NT System Admin Issues
Subject: Re: Quick SQL Question
They are full of shite
On Wed, Oct 20, 2010 at 7:34 AM, James Kerr <cluster...@gmail.com> wrote:
We have a software vendor thats telling me we need to buy a server solely
for running reports on another database. It uses SQL server 2008. We already
have a server in place that has plenty of horsepower that currently has another
application on it the uses SQL 2008. I asked if we could just use that existing
server and I was told the following. "it requires the default SQL instance to
work and should not run on a server with another named instance of SQL". I have
the feeling they are full of it but my SQL knowlege is very limited, the
hardware specs for the server are not very high and it doesnt look like this
report server uses much resources other then high disk IO when running reports
or importing data (at night) from the other database it reports on. I really
don't want to buy another server. What say some of the folks on the list?
James
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin
