January 3, 2008 at 1:25 pm
Hi ,
Am not able to attach a database am getting the following error
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "D:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\WSS_Search_AST430_log.LDF". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'WSS_Search_AST430'. No entry found with that name. Make sure that the name is entered correctly.
January 3, 2008 at 2:16 pm
Have you checked to make sure the file itself isn't marked read-only?
Tommy
Follow @sqlscribeJanuary 3, 2008 at 2:37 pm
Either the file is marked as read-only, or the file is truly in use by another process.
January 3, 2008 at 2:47 pm
- is there a d-drive
- does the path exist ?
- does the sqlsever service account have the authority to read/write to that path ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 3, 2008 at 4:06 pm
i made the server connections to single user mode so there is no other connections to that i feel.
January 4, 2008 at 12:48 am
- can you post the results of xp_fixeddrives ?
- can you post the results of :
exec master..xp_fileexist 'D:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\WSS_Search_AST430_log.LDF'
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 4, 2008 at 3:31 am
Thanks Everyone
I have solved the problem by copying the LDF to another drive and then attached the database giving the new LDF path.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply