Fillfactor at 10 took all my free space

I do a lot of bcping and was trying to speed it up by changing the
fillfactor on a clustered index, and now the database has doubled in size
from 200 to 400 gb and there is no free space left but the process keeps
running. Short of restore, what can I do to get the process to end?Have you tried killing the process from QA ? Find out the
spid of the running process and then open up another
window in QA and issue KILL <spid> command to end the
process.
hth.
>--Original Message--
>I do a lot of bcping and was trying to speed it up by
changing the
>fillfactor on a clustered index, and now the database has
doubled in size
>from 200 to 400 gb and there is no free space left but
the process keeps
>running. Short of restore, what can I do to get the
process to end?
>
>.
>

Filegroup Backup and Restore Issue

Can filegroup speed up the process of backup and restore?
Peter,
All databases have a filegroup called the primary filegroup. The
existence of a filegroup therefore does not speed up backup and restore
per se. Using filegroup backups can be used to good effect to back up
unmanageable very large databases (VLDBs), by allowing you to split the
backup over several maintenance windows.
i.e. you could backup group1 on monday, group2 on tuesday, group1 on
wednesday, etc.
For smaller databases (say in the tens of Gigs), you should do full
backups. However, this can vary depending on your requirements.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Peter wrote:
> Can filegroup speed up the process of backup and restore?
>
|||To add to Marks comments, filegroups allow you to make partial backups, and
restore partial backups. You should place each filegroup on a different
disk, then you can restore and backup the filegroups which map to a
particluar disk or raid array..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:57086BDA-AA15-4F53-B40B-21D468959F0D@.microsoft.com...
> Can filegroup speed up the process of backup and restore?
>