Restore Database

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

From: "gbkhor" <gbkhor@xxxxxxxxxxx>
Date: Fri, 10 Jul 2009 09:47:37 +0800

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

.

Follow-Ups:
- Re: Restore Database
  - From: Rubén Garrigós
- Re: Restore Database
  - From: Andrew J. Kelly

Prev by Date: Re: SPQ 2005 Server service pack 3 failed and now I cannot open Accoun
Next by Date: Re: Restore Database
Previous by thread: SQL 2000 DTS Icon
Next by thread: Re: Restore Database
Index(es):
- Date
- Thread

Relevant Pages

Re: Restore Database
... free space and then create additional filegroups/files to distribute the ... Then you can backup this database and restore it to serverB. ...
(microsoft.public.sqlserver.server)
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 ... 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: 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)
Re: Reorg indexes & remove unused space - known problem???
... Reindexing on a as needed basis is not a problem. ... most assuredly auto grow the database. ... But why do you care how much free space is in the files? ... The shrinking is even more expensive. ...
(microsoft.public.sqlserver.tools)