SQL Server Performance

Fillfactor 100%

Discussion in 'General DBA Questions' started by issolla, Apr 23, 2005.

  1. issolla New Member

    My fillfactor reached 100% at the time of backup. I am taking full backup. Unfortunately I dont have any space in my HD also. What shoud I do?
  2. chopeen Member

    What do you mean by 'fillfactor'?

    FILLFACTOR argument from CREATE INDEX statement?
    Amount of free space on your HDD?

    --

    Rediscover the web
    http://www.mozilla.org/firefox/
  3. deepakontheweb New Member

    fillfactor is confusing in your question.

    if you are running short of space while taking full backup..and if backup drive is same where your data and log files are placed then try to shrink database files.. there from you can have some empty space..



    Deepak Kumar

    --An eye for an eye and everyone shall be blind
  4. dineshasanka Moderator

Share This Page