SQL DBA problem

1,235 pts.
Tags:
Windows Server
Windows Server 2008
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
ASKED: November 28, 2011  11:40 AM
UPDATED: February 28, 2012  3:55 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Eliyevelxan
    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
    1,235 pointsBadges:
    report
  • Eliyevelxan
    [...] A member’s SQL database was resized to zero. The culprit? Maybe anti-virus or a corrupt filesystem, according to [...]
    0 pointsBadges:
    report
  • Eliyevelxan
    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
    1,235 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following