My log file has grow the disk full

My logfile has grow the disk full - the logfil is 25 gb and I have 4 gb free.
I can't shrink the log fil !
Can I set the log file to null ??
I have backup my datafil successfully!
Help!Detach the database, and the delete the log-file manually. Re-Attach the Database, a new log file would be created.|||Thank you :-)|||Originally posted by TALAT
Detach the database, and the delete the log-file manually. Re-Attach the Database, a new log file would be created.

I get a : Error 1813: Could not open new database 'xxxx'. Create database is aborted. Device activation error. The fysical file name 'xx'
may be incorrect.

??|||Detach the DB, rename the existing Log File and then attach the database and it will prompt for a new log file, say ok and you should be all set.
Otherwise:

Backup Tran DBName with No_log
then do
use dbname
dbcc shrinkfile(logfilename,truncateonly)|||Originally posted by sqlserver2k
Detach the DB, rename the existing Log File and then attach the database and it will prompt for a new log file, say ok and you should be all set.
Otherwise:

Backup Tran DBName with No_log
then do
use dbname
dbcc shrinkfile(logfilename,truncateonly)

How can I write the path ?? "e:\logfile\logfilename" don't work ?

The SQLserver can't find the file in sysfiles!

<dbcc shrinkfile(logfilename,truncateonly)> ?|||What exactly are u doin? Restoring the DB? Check if the file name has an extension and u r missing the .tran or .bak extention in the Quotes.|||By this time you might have detached the database using SP_DETACH_DB.

Now delete the existing >LDF file from the path and use SP_ATTACH_SINGLE_FILE_DB to reattch the database which will create new log file as specified.

Books online would be the best help in this regard.|||Originally posted by Satya
By this time you might have detached the database using SP_DETACH_DB.

Now delete the existing >LDF file from the path and use SP_ATTACH_SINGLE_FILE_DB to reattch the database which will create new log file as specified.

Books online would be the best help in this regard.

Tanks for your reply :-)

EXEC sp_detach_db @.dbname = 'xxx'

EXEC sp_attach_single_file_db @.dbname = 'xxx',
@.physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\xxx.mdf'|||Yes thats correct and what was the result.:)