We have the option of purchasing a database server and an IIS server.  Do you know if it is common practice to install Reporting Services on a separate IIS server? ...

Thanks. 

Here are two links discussing the proposed configuration.  The explanation is a bit over my head so I need to do some research.  I'm also curious if this only applies...

Thanks Steve.  This helps.

Dave

Hi Zubeyir,

We have over 50 SQL Servers so converting to SMTP will take some planning.  I was hoping to do this later in the year, but have reconsidered since we...

I've tried that and unfortunately it didn't solve the problem and neither does restarting the SQL Server Agent service.  Part of the problem is explained as follows.

"The SQL Server Agent...

In regards to the fragmentation that's what I was trying to remember.  I know the physical location on disk has a good chance of being less fragmented, assuming the database...

Why would a restore change the stats? 

Hi Steve,

Unfortunately your suggestion didn't work.  We just rebooted our domain controllers and sure enough several of our SQL Servers experienced the MAPI email problem where xp_sendmail hangs.  I ran...

I'll try that the next time xp_sendmail hangs on a server, but I'm thinking I tried that once before and received a message indicating it is already started.  The problem...

The command is fully qualified.  It worked a few weeks ago, but the server experienced problems and was rebuilt.  Something permissions-related is probably messed up, but I can't figure it...

I'm not sure how they plan on analyzing the results.  I've only been asked to address the perfmon piece of the request.

Dave

I spoke with EMC this morning and they agreed 2 hours was not enough.  We're going to run the trace for 1 week, although on some of our servers one...

Thanks.  They will be checking for inventory changes daily and performing full scans monthly.  I'll keep an eye on the performance.

Dave

Thanks all.  I've asked the following be excluded from scans.

Database and Backup Files

.mdf

.ndf

.ldf

.bak

.trn

Full Text Catalogs

FTDATA directory (Only the location...