Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
propanecan
Yak Posting Veteran
60 Posts |
 Posted - 2006-02-17 : 17:52:36
|
| I detached a database and copied the data and log files to another logical partition. The attach works successfully, however the database is now in 'read-only' mode. When I attempt to update the database properties I get the following message:Server:Msg 5105, Level 16, State 10, Line 1Device activation error. The physical file name 'FullPathToLogFile\LogFileName.ldf' may be incorrect. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-17 : 17:54:21
|
| Try attaching only the MDF via sp_attach_single_file_db as your LDF file may be corrupt.Tara Kizeraka tduggan |
 |
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2006-02-17 : 18:06:24
|
| The command runs successfully, but I'm still getting the same error.The physical file name 'F:\SQLDATA\LOADTEST_Data.MDF' may be incorrect. The physical file name 'C:\SQLDATA\LOADTEST_Log.ldf' may be incorrect. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-17 : 18:08:59
|
| It doesn't sound like you've got good database files. You might need to contact MS for this or try posting the data corruption forum here where MS engineers respond to posts.Tara Kizeraka tduggan |
|
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2006-02-17 : 18:17:36
|
| Thanks. It looks like the 're-sizing' of the server partitions may have resulted in corruption. I think I'm going back to the last known good backups. At least this is only development. |
|
|
|
|
|
|
5105 error after attaching database