ITNinja

Restore WithTransact-SQL

 

-Click “NewQuery” in the Management Studio’s main toolbar. This opens a large text area onthe right side of the screen.

 

-Click in thetext area and type a Create Database statement using the following Transact-SQLcode as a guide:

CREATE DATABASEMyDatabase ON (FILENAME = 'c:\data files\my_data.mdf'), (FILENAME = ' c:\datafiles\my_data.ldf') FOR ATTACH;

 

-Click the“Execute” button in the Transact-SQL toolbar, located just under the ManagementStudio’s main toolbar. The Execute button symbol is a right-pointing triangle.SQL Server Management Studio restores the database.

 

Helpfulresources to explain another methods of restoration and gave more variants ofsql data recovery...

https://social.technet.microsoft.com/Forums/en-US/cc4cfcf8-93ad-4d8e-98db-9f241543da89/my-database-mdf-file-got-corrupted?forum=ssdsgetstarted

http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1492-sql-database-corruption-on-sql-2014

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

Here is one of the best solutions that can easily fix all corruption issues in ACCDB and MDB database with Access File Recovery Tool that easily repairs corrupt MS Access (.MDB or .ACCDB) database file and then recover tables, queries, forms, macros, reports, etc. It also restores permanently deleted data from MDB file of MS Access 2013, 2010, 2007, 2003, 2002, 2000 on your latest Windows 8.1 PC & all below Windows version like as Win8, Win7, Vista, 2003 and XP.

For more Help please visit here.. http://www.mannatsoftware.com/stellar-phoenix-access-recovery.html

First, do NOTHING until you have copied the database files somewhere safe!! You don't want to completely negate any chance of recovering your data.

Second, source a backup program and use it! More importantly, you absolutely *have* to test that the back-ups can be restored. I cannot count the number of clients I've worked for who don't do this part and then get bitten when they want to restore data.

As backup is not available then, you need to find the main reason of database corruption, If it is non clustered index then, you can drop and rebuild it. If it is clustered index then, you need to repair it. 

You can repair the database using DBCC CHECKDB repair options. Before running dbcc checkdb repair allow data loss, you need to set the database into Emergency and  single user mode. 

ALTER DATABASE  dbName  SET  EMERGENCY

ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CHECKDB (dbName, REPAIR_ALLOW_DATA_LOSS)

Note: DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS may help you fix all the errors and repair them; however, it can cause data loss from the repaired database.

If you want to bypass all these steps and do not want to lose your data then, you can try SQL recovery software. Stellar Repair for MS SQL is recommended by SQL database admins and experts globally to repair and restores corrupt SQL database. Read more about the software from here: https://www.stellarinfo.com/sql-recovery.php

more sites info:
https://www.invertia.com/es/foros/-/message_boards/message/139416050
https://onmogul.com/products/el-trasero-de-mi-hermana
https://onmogul.com/products/don-francisco
https://onmogul.com/products/viaje-de-placer-familiar
http://www.pearltrees.com/micuki/item203201175
http://www.pearltrees.com/micuki/item203201530
http://www.pearltrees.com/micuki/item203201646
http://www.pearltrees.com/micuki/item203201745
https://www.webhostingdiscussion.net/forums/index.php/topic,31335.0.html
https://www.webhostingdiscussion.net/forums/index.php/topic,31336.0.html
http://freespaceway.com/ninfomanas/dedeando-a-mi-prima/
http://freespaceway.com/ninfomanas/mi-sobrina-politica/
http://freespaceway.com/ninfomanas/la-bodega/
http://freespaceway.com/ninfomanas/marta-la-sumisa/
http://freespaceway.com/ninfomanas/mi-hermano-marcos/

This article will describe the detailed steps to fix SQL Database in Recovery Mode with different methods. It also includes the primary cause behind the SQL Database stuck in Recovery Mode. However, if these recovery processes fail to fix this recovery mode issue, use SQL Database Recovery Tool to regain access to the database.

SQL Database Recovery is a comprehensive Windows-based product that performs seamless recovery in no time and recovers crucial data from corrupted MS SQL database files. The utility successfully restored SQL database objects without any hassle. The SQL Database recovery software can easily repair and recover corrupt MDF as well as NDF file extensions without harming the original data. 

Download Now: https://www.sysinfotools.com/recovery/ms-sql-database-recovery.php