Home Forums SQL Server 7,2000 Data Corruption Attach MDF file with no LOG RE: Attach MDF file with no LOG
Krishnan Kaniappan
Ten Centuries
Points: 1051
More actions
February 15, 2006 at 11:16 am
#621137
When u attach the db with no log file, the device activation error occurs and sql server creates a new log file..
After executing the attach statement, exec sp_helpdb 'dbname' should give you the locations of the files..
-Krishnan