attach db when log error? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

attach db when log error?

SQL Server 2000 Because of host restarting , one error of log file in my db occured . i know how to online my db by empty log file or other idea ? the datafiles are all valid . thanks !
Try sp_attach_single_file_db.
Or rename log file, use EM to attach database and EM aks if you wish a new log file.
Luis Martin
Moderator
SQL-Server-Performance.com
]]>