April 16, 2012 at 12:28 am
Hi,
I had situation where one of my windows 2003 server is crashed, after few days we re-installed windows 2003 and then after i installed sql server 2000.
Then i attached the .mdf & .ndf files to database.
Then i came across some errors like
1.Invalid Protocol specified for a ?????t?c?????t?????? instance: ???y?????t?c?????t??????.
2.SuperSocket Info: Bind failed on TCP port 1433.
3.LogEvent: Failed to report the current event. Operating system error = 31(A device attached to the system is not functioning.).
Then on-wards data is not storing in .mdf files (On drive it is showing last files attached date - its not showing recent data when last data is modified)
But daily i am taking the backups - backups only is happening.
I don't know where does data is saving or storing, every 10 days we restart the server.
So please provide any solution for this situation
April 18, 2012 at 11:38 am
I think I mught understand a little of what you are asking ...
... however to clarify things I would ask you to stop and restart your SQL Server instance and then attach the SQL Server errorlog filform right after the response.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
April 18, 2012 at 12:47 pm
msmartsairam (4/16/2012)
Then on-wards data is not storing in .mdf files (On drive it is showing last files attached date - its not showing recent data when last data is modified)
The modified date on a sql database file is not the time data was last changed in that file. SQL Server doesn't update the file timestamps every time it writes, that would be massivly inefficient.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply