Reporting Services Tip #2:
The easiest way to install Reporting Services is to have the Report Server and SQL Server on the same server. It's the easiest way, but it certainly is not the best. IIS should not be installed on the database server for performance reasons. Now this isn't true for small systems, but I rarely work on small systems so this is a general rule for me. Due to this rule, the Report Server must be installed on a different server as it relies on IIS. And yes this way requires the Report Server to be licensed as well...
EDIT: Please see my new version of this stored procedure.
I've been asked a few times if there was a way to change the number of days to retain the backup files for in my backup stored procedure. Due to this, I have modified the sproc so that you can now input the number of days to retain the files for. Here is the updated version:
----------------------------------------------------------------------------------------------------
-- OBJECT NAME : isp_Backup
--
-- AUTHOR : Tara Duggan
-- DATE : December 18, 2003
--
-- INPUTS : @Path - location of the backups
-- @dbType - which databases to backup - All, System, or User
-- @Retention - numbers of days...