disaster help please!

Hi,
working with sql server 2000.
One of my server's tempdb log is filled up because the
server is running out of space on the t-log disk.
I can't even shrink any db t-log files because it indicate
that they are not in sysfiles.
I rebooted the server, server came backup so does the sql
services, but tempdb log still not freed up.
I can't access to any db including master now!!
I think one of my bcp in process is creating a locking on
auto-shrink process. This db is on auto-shrink in simple
mode.
What should I do?
JJHi.
can you use this ?
backup log DATABASE_NAME with no_log
>--Original Message--
>Hi,
>working with sql server 2000.
>One of my server's tempdb log is filled up because the
>server is running out of space on the t-log disk.
>I can't even shrink any db t-log files because it
indicate
>that they are not in sysfiles.
>I rebooted the server, server came backup so does the sql
>services, but tempdb log still not freed up.
>I can't access to any db including master now!!
>I think one of my bcp in process is creating a locking on
>auto-shrink process. This db is on auto-shrink in simple
>mode.
>What should I do?
>JJ
>.
>|||Radical Solution for radical problem.
Delete the tempdb database then re-create it
J
>--Original Message--
>Hi,
>working with sql server 2000.
>One of my server's tempdb log is filled up because the
>server is running out of space on the t-log disk.
>I can't even shrink any db t-log files because it
indicate
>that they are not in sysfiles.
>I rebooted the server, server came backup so does the sql
>services, but tempdb log still not freed up.
>I can't access to any db including master now!!
>I think one of my bcp in process is creating a locking on
>auto-shrink process. This db is on auto-shrink in simple
>mode.
>What should I do?
>JJ
>.
>|||Hi.
When the sqlserver is restarted ,the Tempdb is recreated.
>--Original Message--
>Radical Solution for radical problem.
>Delete the tempdb database then re-create it
>J
>>--Original Message--
>>Hi,
>>working with sql server 2000.
>>One of my server's tempdb log is filled up because the
>>server is running out of space on the t-log disk.
>>I can't even shrink any db t-log files because it
>indicate
>>that they are not in sysfiles.
>>I rebooted the server, server came backup so does the
sql
>>services, but tempdb log still not freed up.
>>I can't access to any db including master now!!
>>I think one of my bcp in process is creating a locking
on
>>auto-shrink process. This db is on auto-shrink in
simple
>>mode.
>>What should I do?
>>JJ
>>.
>.
>|||thank you so much!!
JJ
>--Original Message--
>Radical Solution for radical problem.
>Delete the tempdb database then re-create it
>J
>>--Original Message--
>>Hi,
>>working with sql server 2000.
>>One of my server's tempdb log is filled up because the
>>server is running out of space on the t-log disk.
>>I can't even shrink any db t-log files because it
>indicate
>>that they are not in sysfiles.
>>I rebooted the server, server came backup so does the
sql
>>services, but tempdb log still not freed up.
>>I can't access to any db including master now!!
>>I think one of my bcp in process is creating a locking
on
>>auto-shrink process. This db is on auto-shrink in
simple
>>mode.
>>What should I do?
>>JJ
>>.
>.
>|||thank you so much!!
why do you want to know whether I can do 'backup log
DATABASE_NAME with no_log'?
JJ
>--Original Message--
>Hi.
>can you use this ?
>backup log DATABASE_NAME with no_log
>
>>--Original Message--
>>Hi,
>>working with sql server 2000.
>>One of my server's tempdb log is filled up because the
>>server is running out of space on the t-log disk.
>>I can't even shrink any db t-log files because it
>indicate
>>that they are not in sysfiles.
>>I rebooted the server, server came backup so does the
sql
>>services, but tempdb log still not freed up.
>>I can't access to any db including master now!!
>>I think one of my bcp in process is creating a locking
on
>>auto-shrink process. This db is on auto-shrink in
simple
>>mode.
>>What should I do?
>>JJ
>>.
>.
>|||JJ Wang wrote:
> thank you so much!!
> JJ
> > --Original Message--
> > Radical Solution for radical problem.
> >
> > Delete the tempdb database then re-create it
> >
> > J
> >
> > > --Original Message--
> > > Hi,
> > >
> > > working with sql server 2000.
> > >
> > > One of my server's tempdb log is filled up because the
> > > server is running out of space on the t-log disk.
> > >
> > > I can't even shrink any db t-log files because it
> > indicate
> > > that they are not in sysfiles.
> > >
> > > I rebooted the server, server came backup so does the
> sql
> > > services, but tempdb log still not freed up.
> > >
> > > I can't access to any db including master now!!
> > >
> > > I think one of my bcp in process is creating a locking
> on
> > > auto-shrink process. This db is on auto-shrink in
> simple
> > > mode.
> > >
> > > What should I do?
> > >
> > > JJ
> > > .
> > >
> > .
> >
FYI when it is recreated it uses modeldb as the template
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||hi.
So many times , Truncating the transaction log solve this
problem .
Truncating the transaction log:
BACKUP LOG { database_name | @.database_name_var }
{
[ WITH
{ NO_LOG | TRUNCATE_ONLY } ]
>--Original Message--
>thank you so much!!
>why do you want to know whether I can do 'backup log
>DATABASE_NAME with no_log'?
>JJ
>>--Original Message--
>>Hi.
>>can you use this ?
>>backup log DATABASE_NAME with no_log
>>
>>--Original Message--
>>Hi,
>>working with sql server 2000.
>>One of my server's tempdb log is filled up because the
>>server is running out of space on the t-log disk.
>>I can't even shrink any db t-log files because it
>>indicate
>>that they are not in sysfiles.
>>I rebooted the server, server came backup so does the
>sql
>>services, but tempdb log still not freed up.
>>I can't access to any db including master now!!
>>I think one of my bcp in process is creating a locking
>on
>>auto-shrink process. This db is on auto-shrink in
>simple
>>mode.
>>What should I do?
>>JJ
>>.
>>.
>.
>