Log file is not available

Dear sir
I have a database of around 116Gb and somehow I lost my
log file , now I am able to attach the database but not
able to do any transaction as I lost the log file.Pls
advice me how to add a log file with this database.
Regards
TriveniHi Triveni,
Check this out!
Restoring databases when only data file available
http://www.sqlservercentral.com/scripts/scriptdetails.asp?
scriptid=599
Regards
Thirumal Reddy M
www.sstil.com
>--Original Message--
>Dear sir
>I have a database of around 116Gb and somehow I lost my
>log file , now I am able to attach the database but not
>able to do any transaction as I lost the log file.Pls
>advice me how to add a log file with this database.
>Regards
>Triveni
>.
>|||Hi !!
Did not find anything on the below link. pls provide the
suggestion as soon as possible.
>--Original Message--
>Hi Triveni,
>Check this out!
>Restoring databases when only data file available
>http://www.sqlservercentral.com/scripts/scriptdetails.asp?
>scriptid=599
>Regards
>Thirumal Reddy M
>www.sstil.com
>>--Original Message--
>>Dear sir
>>I have a database of around 116Gb and somehow I lost my
>>log file , now I am able to attach the database but not
>>able to do any transaction as I lost the log file.Pls
>>advice me how to add a log file with this database.
>>Regards
>>Triveni
>>.
>.
>

LOG file Growing, Similar Issue to a previous one

I have an 19 gig database that somehow has a 100gig log file. The DB MUST BE in full recovery mode, I backup the transaction logs EVERY hour and shrink nightly. but for some reason my logfile WILL NOT SHRINK.

HELP,

I've used both the DBCC Shrinkfile (xxxxxx) and DBCC ShrinkDatabase (xxxxx) and these don't seem to work. I Have No current backup, I have Not capacity for addtional 100 gig worth of backup drive or off-site tape.

I found a solution to my issue. Replication I have setup had a hung transaction.