Restoration size

• shanila_minnu

  Hall of Fame

  Points: 3465

  More actions

  September 24, 2010 at 5:45 am

  #143474

  There is two databases DATABASE1 of 10 GB and DATABASE2 of 20 GB.

  I took the backup of DATABASE1(10GB) and restore it in DATABASE2(20GB).

  After restoration what is the size of DATABASE2 ?

  10 GB or 20 Gb

• Oliiii

  SSCertifiable

  Points: 5328

  More actions

  September 24, 2010 at 6:03 am

  #1226881

  10GB

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  September 24, 2010 at 7:53 am

  #1226981

  Yep 10gb

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 24, 2010 at 8:39 am

  #1227026

  Restoring one database over another is equivalent to first dropping the existing database, then restoring the backup.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  September 24, 2010 at 2:13 pm

  #1227229

  10 GB...