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
