SQL Server Performance Forum – Threads Archive

Fillfactor 100%

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?

---

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/

---

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

---

what do you mean by "reached 100%"
Check
http://www.sqlservercentral.com/columnists/jweisbecker/amethodologyfordeterminingfillfactors.asp

---

]]>