From the course: SQL Server 2012: Designing Database Solutions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using multiple files

Using multiple files - SQL Server Tutorial

From the course: SQL Server 2012: Designing Database Solutions

Start my 1-month free trial

Using multiple files

- In this section, I'd like to demonstrate creating and using new files and new file groups in a SQL Server database. In the Adventureworks database, I'm going to open up Tables, and you'll see the very first table listed is AWBuildVersion, and that is a table that keeps track of which version of the Adventureworks database is currently implemented. To me, that information is not as important as some of the other information in the database, and therefore wouldn't need to be backed up as often. Right now, this table is stored in the primary data file, and therefore is backed up in every backup routine. I'd like to move it to a new secondary data file that we won't back up as often. So, I'll right click on this table, and we'll look at the Properties. And in Properties I want to look at Storage, and under Storage we'll see that it is part of the Primary file group. Notice it doesn't tell me exactly which file in that file group. I don't have that much granular control. I can just say…

Contents