Microsoft ISA Server / SQL 2000
I have had this ISA server working for some time now, approximately 1 year, without any problems what so ever.
Then now I come to find that the service seemed to just lockup.
I look in the even logs to trace down the source of the problem… It’s the SQL 2000 dB! It seems that the dB named has changed somehow. For example, if my database was called ISAdB it’s now called ISAdB (Suspect). I don’t know what the heck happened there. So I drilled down to the location of the actual database files themselves.
I see that my ISAdb_Data Files are there, at the size of about 11Gig’s. I am still pusszelled about the rename of the database, and now thinking of my next steps.
So what I do is attempt to do is reattach the database. And I am giving the following error:
Error 1813: Could not open new database ‘ISAdB’. CREATE DATABSE is aborted.
Device activation error. The physical file name ‘D:\SQL\data\ISAdB_Log.LDF’ may be incorrect.
To fix the issue I have the ISA Server logging its info to TEXT files and not the SQL Db.
Has anyone ever had this issue and can explaine to me how this might have happened, how to prevent, and most of all. How do I go about, perhaps making a new dB for my ISA to log it’s info into.
ODBC DSN is also there…
I was getting the following error when I wanted to start the services for ISA: Error 5159: Operating system error 997 (Overlapped I/O operation is in progress)
But I am sure this is a SQL issue.
“Could it be the dB got to big?”