SQL DBA problem
Hi. I have problem with SQL server 2008. Sql database filesize is becomes 0. SQL worked fine, all was fine. I restarted server and when OS is opens i notices that SQL database filesize =0 kb. Database file situated on Storage. No error log. What may be problem? please help
Software/Hardware used:
IBM
Software/Hardware used:
IBM
ASKED:
November 28, 2011 11:40 AM
UPDATED:
February 28, 2012 3:55 PM
RELATED QUESTIONS
- Permissions for writing stored procedures in MySQL
- Error when restoring a .bak file in SQL Server
- Local clients loose connection to local SQL Server when system network drops connection to HQ.
- How to consolidate databases from different SQL Server versions to one SQL Server 2005 database
- Failed ODBC USER DSN connection to SQL Server 2005
Answer Wiki:
As the prior answer didn't really answer your question at all I've removed it.
If the database files have gone to 0k then you've got some major problems. Either your anti-virus has decided that the database files were infected with something (very possible) and it wiped out the data within the file, or there was some problem with your hard drive that caused the file to be wiped out. Based on your description I'm going with the anti-virus or some other software installed on the computer killed the files.
To get the data back you'll need to have valid SQL Server backups. Without them the data is lost.
To see all answers submitted to the Answer Wiki: View Answer History.
My antivirus is Kaspersky. I checked logs, not look like antivirus problem. But i notice that NTFS file system was problem. Thanks very much for your aswer
The problem resolved. The problem was Cache RAM on storage server. Our storage server is IBM. SQL databasa is on storage. we send problem to IMB and they answer us that tis problem cause is Staorage, and they ugraded the Storage. Thanks All for help