I don't know why this is happening in running condition and the SQL Server error log file has no clue about it....
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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
Troubleshoot long running stored procedures with SQL Server Profiler by adding events to find the command with high run time.continue reading
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
Learn how to troubleshoot SQL Server 2005 temporary table performance problems when a stored procedure execution time is slower than usual.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.