Restore Database FILESIZE

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 !
Thank's
Carrasco> 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 !
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...
> 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 !
> Thank's
> Carrasco