Re: Restore Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Rubén Garrigós

"Rubén Garrigós" <rgarrigos@xxxxxxxxxx> wrote in message
news:%23S3oBmTAKHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
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ó:
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


.

Relevant Pages

  • Re: Restore Database
    ... You can place the log file on another drive but you ... I have one database backup file backup.bak having database file abc.mdf ... I wish to restore the backup into other serverB, ... sufficient harddisk space on Drive D (free space 50GB), ...
    (microsoft.public.sqlserver.server)
  • Re: problem with db restore
    ... which I've got in answer to "restore filelistonly ... got only 40GB free space. ... I've got file "database" without any extension. ... I tried to open it in SQL but it's no use. ...
    (microsoft.public.sqlserver.tools)
  • Re: Restore Database
    ... 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. ... I wish to restore the backup into other serverB, but serverB doesn't have sufficient harddisk space on Drive D, but having sufficient space if I add Drive D and Drive E free space. ...
    (microsoft.public.sqlserver.server)
  • Re: Restore Database
    ... You can place the log file on another drive but you can't split a single file onto more than one logical drive. ... I have one database backup file backup.bak having database file abc.mdf 60GB and Transaction log abc.log 1GB file ... 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 and Drive E free space. ...
    (microsoft.public.sqlserver.server)
  • Restore Database
    ... I have one database backup file backup.bak having database file abc.mdf 60GB ... I wish to restore the backup into other serverB, ... 50GB) free space. ...
    (microsoft.public.sqlserver.server)