I don't know why this is happening in running condition and the SQL Server error log file has no clue about it....
I lost all my office data. The mdf file is 109 mb and ldf is 519 gb. The database has no tables. Is it possible? This has happened to me three times and every time I changed my server PC with new Windows and SQL Server installations. What should I do?
If your database is in SIMPLE recovery mode, there are no products that can recover the data. You will want to evaluate your databases security model. You probably have granted your users too many rights within the database.
Dig Deeper on SQL Server Backup and Recovery
Related Q&A from Denny Cherry
To avoid performance problems when running multiple instances of SQL Server 2005 with Exchange on Windows SBS, refer to these expert best practices. Continue Reading
Planning an upgrade to SQL Server 2008? Our expert weighs in on advantages and hardware requirements you should consider before upgrading to SQL ... Continue Reading
After installing SQL Server 2005, the SQL Server tools may not appear in the start menu. Our expert explains how to troubleshoot this problem. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.