Ramblings of a DBA

Tara Kizer
posts - 166, comments - 835, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

August 2004 Blog Posts

Reporting Services Tip #2

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...

posted @ Monday, August 09, 2004 1:57 PM | Feedback (14) | Filed Under [ SQL Server - Reporting Services ]

Backup databases stored procedure - new version

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...

posted @ Wednesday, August 04, 2004 11:03 AM | Feedback (31) | Filed Under [ SQL Server - Database Administration ]

Powered by:
Powered By Subtext Powered By ASP.NET