**Restoring just the data part of a DB **

Hi
I'm working with SQL 2000,and I've a backup of a full recovery DB from
another server,how can I restore this DB on my server without restoring the
log file,cause it needs a lot space?
Any help would be thankful.You can't. See my prior post (no need to re-post to a new thread). Shrink th
e database before you do
the backup, or make sure you have enough disk space to do the restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M R" <rezvani@.parskhazar.net> wrote in message news:%23tBM1SfVFHA.3076@.TK2MSFTNGP10.phx.gb
l...
> Hi
> I'm working with SQL 2000,and I've a backup of a full recovery DB from
> another server,how can I restore this DB on my server without restoring th
e
> log file,cause it needs a lot space?
> Any help would be thankful.
>|||but I've got the backup from another server which I've no access to that
server to shrink it first,
and I can't make more than avalable space now I have,so is there any other
solution?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uXytGXfVFHA.3944@.TK2MSFTNGP10.phx.gbl...
> You can't. See my prior post (no need to re-post to a new thread). Shrink
the database before you do
> the backup, or make sure you have enough disk space to do the restore.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "M R" <rezvani@.parskhazar.net> wrote in message
news:%23tBM1SfVFHA.3076@.TK2MSFTNGP10.phx.gbl...
the
>|||I'm afraid not. You could try and open a support case with MS and see if the
re exist any hack for
this, but there's no supported or documented way to accomplish this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M R" <rezvani@.parskhazar.net> wrote in message news:e90bd5fVFHA.616@.TK2MSFTNGP12.phx.gbl..
.
> but I've got the backup from another server which I've no access to that
> server to shrink it first,
> and I can't make more than avalable space now I have,so is there any other
> solution?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:uXytGXfVFHA.3944@.TK2MSFTNGP10.phx.gbl...
> the database before you do
> news:%23tBM1SfVFHA.3076@.TK2MSFTNGP10.phx.gbl...
> the
>

**Restoring a db with size 167049KB**

Hi
I'm working with SQL2000 and I want to restore a db which I've got from
another server into my server with this size : 167049KB,and I've 11gb on
Drive E,but following error appearred after restoring:
"There's insufficient free space on disk volume 'e:' to create the
database.the database requires 28614066176 additional free bytes ,while only
2147155 968 bytes are available. Restore databse is terminated abnormally."
why?Can anybody help me?
Any help would be thankful.Do RESTORE FILELISTONLY and check the sum of size for the database files. Th
is is the size of the
database files when you took the backup and this is the space you need to do
restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M R" <rezvani@.parskhazar.net> wrote in message news:OTxT%23eeVFHA.3424@.TK2MSFTNGP09.phx.gb
l...
> Hi
> I'm working with SQL2000 and I want to restore a db which I've got from
> another server into my server with this size : 167049KB,and I've 11gb on
> Drive E,but following error appearred after restoring:
> "There's insufficient free space on disk volume 'e:' to create the
> database.the database requires 28614066176 additional free bytes ,while on
ly
> 2147155 968 bytes are available. Restore databse is terminated abnormally.
"
> why?Can anybody help me?
> Any help would be thankful.
>|||Looks like the database you backed up might have lot of free space in the
data file (.mdf/ .ndf) or/and Huge Log file(.ldf).Check the original
database size. Just looking the backup size of the database could be
deceiving. The backup file is the size of the data in your database it does
not include the free space.
Try to backup the transaction log in the original database/ if you don't
need the transaction backup truncate the log file and shrink the log file
to a reasonable size. Do not shrink the data file (.mdf / .ndf) that might
create fragmentation on the data.
-regards
Sarav...
"M R" <rezvani@.parskhazar.net> wrote in message
news:OTxT%23eeVFHA.3424@.TK2MSFTNGP09.phx.gbl...
> Hi
> I'm working with SQL2000 and I want to restore a db which I've got from
> another server into my server with this size : 167049KB,and I've 11gb on
> Drive E,but following error appearred after restoring:
> "There's insufficient free space on disk volume 'e:' to create the
> database.the database requires 28614066176 additional free bytes ,while
only
> 2147155 968 bytes are available. Restore databse is terminated
abnormally."
> why?Can anybody help me?
> Any help would be thankful.
>