Adding files to database

  • A short piece that demonstrates how to add another file to your filegroup if you're out of space. Discuss the proportional fill algorithm, and show that adding a new file shows most of the writes to to this one.

    Use a small database to make the math easier. Maybe a 10MB file, then add another once it's 90% full.

    Show SSMS + T-SQL for adding a file.

  • I'll write one up for this, Steve. Wrapping up my linked server piece this week then I'll get started on this.

  • Take it, and thanks, David.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply