i have sql database 2005 and the log file when i want to update My sql server to 2008 i found the problem with attach the old datebase file the error is :
Msg 3415, Level 16, State 3, Line 1
Database 'SMMS_test' cannot be upgraded because it is read-only or has read-only files. Make the database
or files writeable, and rerun recovery.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'SMMS_test'. CREATE DATABASE is aborted.
plz help me to solve this problem and i want to attach my old 2005 databases thank all pro
the code i used is :
CREATE DATABASE [SMMS_test] ON
( FILENAME = N'D:\Databases\SMMS_test.mdf' ),
( FILENAME = N'D:\Databases\SMMS_test_log.ldf' )
i use windows vista and sql server 2008 enterprise my instance is windows\Authentication mode I'm admin and it is my local PC
any one can help me ??????????
View Complete Post