problem with restore database

I got a database backup file. By running RESTORE
FILELISTONLY, it shows 50GB mdf file and 200MB ldf file. I
try to restore it on the test server but the test server
doesn't have 50GB free space in one single drive. So, I
can't create one 50GB mdf file. I try to create the test
database with 20GB on one drive and another 30GB on
another drive. But I still can't restore the database.
Is it possible to restore this backup file on this test
server which has limited amount of disk space?
Thanks in advance for suggestion.
Jd.
You must recreate the exact file size and count for a restore. Files do not
have to be in the same location as the backup, but they cannot be split or
shrunk until the restore is complete. In short, if you have a database file
that is 50GB, you need 50GB to restore it. Plan your systems accordingly.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"JD" <anonymous@.discussions.microsoft.com> wrote in message
news:193fe01c4218f$284113d0$a601280a@.phx.gbl...
> I got a database backup file. By running RESTORE
> FILELISTONLY, it shows 50GB mdf file and 200MB ldf file. I
> try to restore it on the test server but the test server
> doesn't have 50GB free space in one single drive. So, I
> can't create one 50GB mdf file. I try to create the test
> database with 20GB on one drive and another 30GB on
> another drive. But I still can't restore the database.
> Is it possible to restore this backup file on this test
> server which has limited amount of disk space?
> Thanks in advance for suggestion.
> Jd.
|||> Is it possible to restore this backup file on this test
> server which has limited amount of disk space?
I'm afraid not. When doing restore, SQL Server will create the same database file layout, each file has the
same logical file name and at least the same size (this includes the transaction log file(s)). This fact is
one reason why you might want to split up the database into several files in the first place.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"JD" <anonymous@.discussions.microsoft.com> wrote in message news:193fe01c4218f$284113d0$a601280a@.phx.gbl...
> I got a database backup file. By running RESTORE
> FILELISTONLY, it shows 50GB mdf file and 200MB ldf file. I
> try to restore it on the test server but the test server
> doesn't have 50GB free space in one single drive. So, I
> can't create one 50GB mdf file. I try to create the test
> database with 20GB on one drive and another 30GB on
> another drive. But I still can't restore the database.
> Is it possible to restore this backup file on this test
> server which has limited amount of disk space?
> Thanks in advance for suggestion.
> Jd.