sql database 2008

[rhysgardner]

Fell virtual server, yesterday raised and moved onto a new backup of 02.12.15 number of backup, whether it is possible to restore the database with a log of the ldf 12.24.15 number

[mLipok]

Which last SQLDatabase backup do you have ?
Virtual server raised automaticaly/himself ?

[karterstout]

You may try both variant of restoration:

 

First powerful resources

 

http://support.oreilly.com/oreilly/topics/it_seems_our_sql_database_is_corrupted?rfm=1 

http://itknowledgeexchange.techtarget.com/itanswers/it-seems-our-sql-database-is-corrupted/ 

https://www.repairtoolbox.com/sqlserverrepair.html SQL Server Repair Toolbox

 

Check DB

Sometimes when you connect to your database server, you may find it in suspect mode. Your database server won’t allow you to perform any operation on that database until the database is repaired.

A database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the database files etc.

To get the exact reason of a database going into suspect mode can be found using the following query,

DBCC CHECKDB (’YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS

 

Output of the above query will give the errors in the database.

To repair the database, run the following SQL Script

EXEC sp_resetstatus ‘yourDBname’;

ALTER DATABASE yourDBname SET EMERGENCY

DBCC checkdb(’yourDBname’)

ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB (’yourDBname’, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE yourDBname SET MULTI_USER