Home Forums SQL Server 2005 Administering Restore DB with actual data size RE: Restore DB with actual data size
Ant-Green
SSC Guru
Points: 113445
More actions
December 5, 2012 at 2:58 am
#1565634
No, SQL must restore the database as it was at the time it was backed up, meaning it must create it with a size of 150GB.
The only thing would be to shrink it after restore if you cant shrink the source.