September 12, 2011 at 11:33 am
I know this is driving people crazy, there is a 2000 server with only sp2! and it crashed! I am called to investigate, can anyone tell me where to start? I don't even see the DB in the EM
September 12, 2011 at 11:41 am
Any drive letter detached on the san?
NTFS permission changed?
Anything usefull in the sql error logs?
September 12, 2011 at 11:49 am
Operating system error 2(The system cannot find the file specified.) on device 'D:\Sql\SELS_log.LDF' during ForwardLogBlockReadAheadAsync.
September 12, 2011 at 11:55 am
Further track down in eventviewer shows the cause might traced back to much earlier:
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(6)
Event ID:17055
Date:1/1/2011
Time:1:00:01 AM
User:NT AUTHORITY\SYSTEM
Computer:ISCSLSDB
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [SELS] TO [SELS Disk Backup] WITH INIT , NOUNLOAD , NAME = N'SELS backup', NOSKIP , STATS = 10, NOFORMAT
September 12, 2011 at 12:01 pm
Never thought happiness can come so early!!!!!!!
I made a copy to another SQL 2000 server, the DB is up and running there!!!:w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:
September 12, 2011 at 3:13 pm
Has to be permissions!
March 12, 2019 at 11:24 am
Probably permissions
But in my case, it wasn't
Error message said:
FCB::Open failed: Could not open file E:\UserDatabases\msdb.mdf for file number 1. OS error: 2(failed to retrieve text for this error. Reason: 15100).
BUT
Someone had renamed the file as MSDBData.mdf
Just check, might save you from tearing your hair out when you can't find the permissions problem!
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy