Too big ldf file

Thanks but we can not reach the database right now.  We have found a way.
We may delete the ldf file and then use sb_attach query to recreate the ldf file.
Our solution work for smaltrivial databases.

But the mdf file size is 30 GB and the ldf file is 140 GB.
We are kind of scary to delete the ldf file :)
Only operation we can do to the database is to detach it. Shrink or etc is not working currently, or back up...

Hi,

have you tried
backup log myDatabaseName with truncate_only
and then shrinking the file?

You may need a couple of iterations.

First make sure you have a full-backup. after log is shrunk take full backup.

Cheers
  David

thanks but like i said ,
when i right click  my database , back up or shrink is inactive.
so i can not use back up right now.

why do it in QA

0 am not sure i understand that but currently we can't run any queries either.

Is the service running?

yes it is  currently running. There are other small databeses on the server that  are working fine.

thanks for your article . My case is the "disk space problem."

normally i may right click then select properties and then add a new logfile.

But when i select properties  it throws an exception "data base inaccessible due to insufficient hard
disk space".   error code 945

thanks david.

are there any other databases that you can shrink or move to free up some space first?

I have other  partitions that have enough disk space.
But i am so afraid of playing with the ldf file. (0f i lost the database that will be a real pain....)

But i see that only way to free up my  partition is to somehow delete the ldf file and the use sb_attach.