Results 1 to 7 of 7

Thread: RS SQL Server Database Maintenance

  1. #1
    Join Date
    Sep 2006
    Posts
    5

    RS SQL Server Database Maintenance

    Hi,
    I'm researching on how to maintain RS SQL server database or what is the best way to maintain ReportServer and ReportServerTempDB? Should I go for the automatic shrink facility of SQL Server? Any suggestion? Thanks.
    Last edited by Naga; 09-18-2006 at 04:58 AM.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Usage on those dbs are light, I'll not auto shrink them unless have disk space issue.

  3. #3
    Join Date
    Sep 2006
    Posts
    5
    Well, that's the problem. Reports we’re generating mostly contain thousands of pages. During application testing, the size of our DB’s physical file reached around 200MB. Is there any way that we can control this? Or is there a proper way of handling this? Thanks.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Your server doesn't have 200mb space to host the dbs? Add disk or move them to separate server if so.

  5. #5
    Join Date
    Sep 2006
    Posts
    5
    Probably the question should be -> will the report databases (physical data and log files) continue to grow while we're using it? if so, should there be proper handling for this. Our reports generate around 2474 pages when exported to pdf file format. Thanks.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Not really since RS doesn't store report in db.

  7. #7
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    2474 page report? Oh, My ...

    You could always try adding "intelligence" to the report(s), parameterizing, and the like, to allow users to reduce the span of focus - one has to wonder how useful a 2,474 page .pdf can be to a user, when params and other finesse might mean focused, self-serve answers in an interactive environment.

    Just my opinion ...

    Bill

    William E. Pearson III
    CPA, CMA, CIA, MCSE, MCDBA
    Island Technologies Inc.
    931 Monroe Drive
    Suite 102-321
    Atlanta, GA 30308

    404.872.5972 Office

    http://www.databasejournal.com/article.php/1459531

    wep3@islandtechnologies.com
    wep3@msas-architect.com

    www.islandtechnologies.com

    www.msas-architect.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •