Wednesday, March 7, 2012

Restoring from a fixed allocated database?

We have a backup of a database that is from a database with a fixed
allocation size of 300GB. The actual data itself is small, is there any way
to restore this database without needing 300+GB of space?
Thanks!Not really. You either have to shrink the existing db and do another backup
or export the data and import it into a copy of the db schema (that has much
smaller files).
--
Andrew J. Kelly SQL MVP
"Steven H" <heinz_steven@.emc.com> wrote in message
news:e0qhLigzGHA.4204@.TK2MSFTNGP04.phx.gbl...
> We have a backup of a database that is from a database with a fixed
> allocation size of 300GB. The actual data itself is small, is there any
> way to restore this database without needing 300+GB of space?
> Thanks!
>

No comments:

Post a Comment