我用的是SQL Server 7。0
用一下命令
EXEC sp_attach_db @dbname = N'aa1',
@filename1 = N'c:\mssql7\data\ls.mdf',
@filename2 = N'c:\mssql7\data\ls_log.ldf'
提示
Server: Msg 9004, Level 21, State 1, Line 1
The log for database 'aa1' is corrupt.Connection Broken
怎么办呀?还能看到以前的数据吗?
用一下命令
EXEC sp_attach_db @dbname = N'aa1',
@filename1 = N'c:\mssql7\data\ls.mdf',
@filename2 = N'c:\mssql7\data\ls_log.ldf'
提示
Server: Msg 9004, Level 21, State 1, Line 1
The log for database 'aa1' is corrupt.Connection Broken
怎么办呀?还能看到以前的数据吗?
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
楼顶不是有朋友说了嘛?