**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
>