I have a database that has 2 files each one with 50 GB - 20 GB used in each
file ! So I have 30 GB free in each file ! I wanna make a restore in another
machine ! And I have the same volume letters, but in one volume I have only
45 GB free ! and in the ot
her I have 90 GB ! Is there a way to decrease the file while making a restor
e so the file can fit in the unit that has only 45 GB free !
Thank's
Carrasco> Is there a way to decrease the file while making a restore
quote:
> so the file can fit in the unit that has only 45 GB free !
You can move database files during the restore but the number and size of
the files will be exactly like the original. If you need to restore to a
server that doesn't have enough space, you'll need to restore to an
adequately sized machine, shrink the files, backup the smaller db and then
restore to the desired server.
Hope this helps.
Dan Guzman
SQL Server MVP
"Carrasco" <anonymous@.discussions.microsoft.com> wrote in message
news:4A0862C9-822C-4603-9E00-6546C5FCE56F@.microsoft.com...
quote:
> Hi,
> I have a database that has 2 files each one with 50 GB - 20 GB used in
each file ! So I have 30 GB free in each file ! I wanna make a restore in
another machine ! And I have the same volume letters, but in one volume I
have only 45 GB free ! and in the other I have 90 GB ! Is there a way to
decrease the file while making a restore so the file can fit in the unit
that has only 45 GB free !
quote:
> Thank's
> Carrasco
No comments:
Post a Comment