Restore Database

10 Jul 2009 1:47 AM

gbkhor

Hi

I running SQL2K SP4 at Win2003 OS

I have one database backup file backup.bak having database file abc.mdf 60GB
and Transaction log abc.log 1GB file

Question:
I wish to restore the backup into other serverB, but serverB doesn't have
sufficient harddisk space on Drive D (free space 50GB), but having
sufficient space if I add Drive D (free space 50GB) and Drive E (free space
50GB) free space.

How do i able to restore the the database into ServerB? kindly advice

Thanks a lot

10 Jul 2009 2:01 AM

Andrew J. Kelly

You can't. You need a single logical drive that has at least 60GB free on it
for the data file. You can place the log file on another drive but you can't
split a single file onto more than one logical drive.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

Show quoteHide quote

"gbkhor" <gbk***@hotmail.com> wrote in message
news:%23suOpBQAKHA.4496@TK2MSFTNGP02.phx.gbl...
> Hi
>
> I running SQL2K SP4 at Win2003 OS
>
> I have one database backup file backup.bak having database file abc.mdf
> 60GB and Transaction log abc.log 1GB file
>
> Question:
> I wish to restore the backup into other serverB, but serverB doesn't have
> sufficient harddisk space on Drive D (free space 50GB), but having
> sufficient space if I add Drive D (free space 50GB) and Drive E (free
> space 50GB) free space.
>
> How do i able to restore the the database into ServerB? kindly advice
>
> Thanks a lot
>

10 Jul 2009 8:36 AM

Rubén_Garrigós

Hi gbkhor,

I will recommend you to restore the database in another server with
enough free space and then create additional filegroups/files to
distribute the data. Then you can backup this database and restore it to
serverB.

You can also try to "shrink" D and E partitions and create a spanned
volume but this is a not as good alternative as the first one:
http://technet.microsoft.com/en-us/library/cc784653(WS.10).aspx

--
Rubén Garrigós
Solid Quality Mentors

Blog: http://blogs.solidq.com/es/elrincondeldba

gbkhor escribió:

Show quoteHide quote

> Hi
>
> I running SQL2K SP4 at Win2003 OS
>
> I have one database backup file backup.bak having database file abc.mdf 60GB
> and Transaction log abc.log 1GB file
>
> Question:
> I wish to restore the backup into other serverB, but serverB doesn't have
> sufficient harddisk space on Drive D (free space 50GB), but having
> sufficient space if I add Drive D (free space 50GB) and Drive E (free space
> 50GB) free space.
>
> How do i able to restore the the database into ServerB? kindly advice
>
> Thanks a lot
>
>