Do i need to shrink database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MANU1k
    New Member
    • Jul 2007
    • 3

    #1

    Do i need to shrink database

    My database properties show Space Available 0.00 MB.
    And users complain the application is very slow. Do i need to do a database shrink? Also can i schedule db shrink on a weekly basis is that advisable?
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    There a lot of factors including your T-SQL, your design, your table and db structure, etc...

    Shrinking database is not always OK, sou you have to assess everything first.

    Good Luck!!!

    ~~ CK

    Comment

    Working...