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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply