Link to home
Start Free TrialLog in
Avatar of Member_2_1242703
Member_2_1242703

asked on

sp_add_log_file_recover_suspect_db [ @dbName = ]????

I lost a transaction log because of hardware failure. I've taken an affected DB offline and cannot bring it online. My research points me to the tsql in the title but I'm struggling on how to use it. Can someone post an example.

OR

Is there another way to create a new ldf for an offline DB?

TIA
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Member_2_1242703
Member_2_1242703

ASKER

Oh ok. Thanks!