Find solution
What files are included in the file backup?

Are files and file groups included when doing a full backup?

  • I have a database with 4 files and 2 file groups. According to the size of the files, it's 1TB. However, the backup (non-compressed) is only 350GB. Is this typical? Or, do I need to specifically select every file/file group when doing backups?

  • Answer:

    A full backup is everything... SQL Server backups will only contain the actual data in the database. The size of the physical file is the allocated size that SQL Server has for the file, including the free space. It does however also keep up with the initial size of your files for the database in the backup as well. So when you restore the database the files will be created and attempt to allocate the same amount of space.

srtr4k at Database Administrators Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.