Hello All !
The context: on a server, I have a SQL server 2008 database SP1 (x64 - US). This DB had never been backuped since 3 or 4 years. The last day, somebody decides to backup it because out of space (backup database db to disk = 'F:\save\db.bak'). The "db.bak"
is 25 GB. This DB was in Full recovery mode. Then this DB is set to "simple" recovery mode. A shrinkdatabase command was ran on this db and another backup was done.
Normally, this db should be at 5 Gb for 3 or 4 exploitation years.
Results: customer phones and : log db file is about 146 GB and the DB seems "bad". When they run "dbcc checkdb" on this DB, the query is very, very, very long and no result.
How can I recover this DB ?
Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2
View Complete Post