September 24, 2009 at 4:25 am
Hi Guys,
I have a bit of a problem here, I have stopped the SQL service on server A, copied the mdf files and ldf files across to server B and now I’m trying to attach the files on server B, but for some reason the databases do attach but sets the status of the database to read only.
If I try to change the status of the drive to READ_WRITE, I get the error below.
Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name 'E:\XXXXXX.MDF' may be incorrect.
Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name 'E:\ XXXXXX.LDF' may be incorrect.
Device activation error. The physical file name 'E:\ XXXXXX.LDF' may be incorrect.
Msg 5181, Level 16, State 5, Line 1
Could not restart database 'Lucerne_snap'. Reverting back to old status.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Can someone help here.
September 24, 2009 at 4:32 am
Dean Jones-454305 (9/24/2009)
Hi Guys,I have a bit of a problem here, I have stopped the SQL service on server A, copied the mdf files and ldf files across to server B and now I’m trying to attach the files on server B, but for some reason the databases do attach but sets the status of the database to read only.
If I try to change the status of the drive to READ_WRITE, I get the error below.
Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name 'E:\XXXXXX.MDF' may be incorrect.
Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name 'E:\ XXXXXX.LDF' may be incorrect.
Device activation error. The physical file name 'E:\ XXXXXX.LDF' may be incorrect.
Msg 5181, Level 16, State 5, Line 1
Could not restart database 'Lucerne_snap'. Reverting back to old status.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Can someone help here.
Silly question I know, but does the e:\drive and path actually exist on the new server. you dont mention that you deattached the databases before you stopped the serice. I take it that you did deattach the databases?
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 24, 2009 at 4:41 am
Looking at your post again, Would i be correct in thinking that you have 1 database there with 2 log files?
if that is the case, that might explain your problem, depending on how you are doing your attach
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply