Wednesday, March 21, 2012

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
>>.
>.
>

No comments:

Post a Comment