empty sql transaction log

[mirage10]

Hi,
we have sql server 2000 database.
while creating the database- the
transaction_log file size was set to 8 GB..(some how.. in error)
our hard disk space is only 10 GB.. and transaction log filled up the hard disk.

i have tried dbcc shrinkfile -with emptyfile,
with truncateonly-.. this only reduced the file size by a little bit.. i want to reduce the file size to 500 mb..
and i donot need the contents of the transaction log file..
(i have also backed up the transaction log file.. still the file size was not reduced much)

can i in some way delete this file and re-created the log file with 500mb??


------------------------------------------
A Man can be only as happy.. as he makes up his mind to be

 

[jbrusie]

Thats funny, I have the same problem...but mine is 43gig...MS site says that you can't shink it smaller then what it was created to be...so the option would be to delete and recreate, but I have no clue on that one...any help out there?

Thanks

 

[mrdenny]

Do the DBCC Shirnkfile command again and copy and paste the output into the forum.

You can detach the database, rename the log file and reattach the database and it should create a new log file. Every once and a while the procedure to attach and create a log file doesn't work correctly so be sure to do a full backup before detaching the database.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com