0
0738
Unregistered / Unconfirmed
GUEST, unregistred user!
前两天重装机器前,我把数据库"Stores"对应文件"stores.mdf"做了 copy,由于log文件太大,
直接将其删除了.做完系统恢复数据库时在sql analysis 中使用以下语句:
sp_attach_single_file_db 'Stores','c:/Mssql7/Data/stores.MDF' 和
sp_attach_db 'Stores','c:/Mssql7/Data/stores.MDF'
均出现以下错误提示:
Server: Msg 945, Level 14, State 2, Line 1
Database 'Stores'cannot be opened because some of the files could not be activated.
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'Stores'. CREATE DATABASE is aborted.
直接将其删除了.做完系统恢复数据库时在sql analysis 中使用以下语句:
sp_attach_single_file_db 'Stores','c:/Mssql7/Data/stores.MDF' 和
sp_attach_db 'Stores','c:/Mssql7/Data/stores.MDF'
均出现以下错误提示:
Server: Msg 945, Level 14, State 2, Line 1
Database 'Stores'cannot be opened because some of the files could not be activated.
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'Stores'. CREATE DATABASE is aborted.