1. lara99 New Member

   Hi guys simple question, If I do a full backup of 20G database will the
   backup file also be 20G long.

   lara99, Dec 31, 2007

   #2
2. Luis Martin Moderator

   Not always. If you have a filegroup, said 10GB, and it is fill only 5GB, then backup will store only 5GB. Now, also SQL store the filegroup size, so when you try to restore, you have to have 10GB of space.
   

   Luis Martin, Jan 1, 2008

   #3
3. satya Moderator

   Whats the problem in performing the database backup to a file and see the size of it?
   Refer what Luis said above.
   

   satya, Jan 2, 2008

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in