Recover tables,Views, Sql Server

Do you have valid .MDF file without .LDF ?

If So, You can attach the .MDF file and access the Objects. How ?

Check It Out !

USE MASTER

GO



CREATE DATABASE DotnetFunda ON (FILENAME = N'YOUR .MDF FILE PATH')

FOR ATTACH_REBUILD_LOG

GO

Now, your .MDF file has been attached with new database named "DotnetFunda"

Now You can access your Objects!

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

Hai

what is .ldf and use of it?

only we revcover our data without .ldf

How can i check the .mdf file is valid or not
What do you mean by valid here


Thanks

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

- We need minimum 2 Files for a Database (.MDF and .LDF)
- But, You can recover your objects from .MDF without .LDF (By attaching the .MDF using the step given in previous reply)
- Just try to attach the .MDF file and you can access the objects from that DB (So, This is valid) (or) The file may not be corrupted!

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

Hello,
You can try to
use Kernel for SQL Recovery software that is not only easy to use but its interactive and user-friendly screens makes this tool a favorite among novice computer users as well It will repair your corrupt MDF file and extract all tables, triggers, views and stored procedures. A batch file for recovered objects can also be created and to easily save them to new database created on SQL server.

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

You can recover your tables from the mdf file by attaching it with the SQL server.
You can attach the file with the help of attach command or SQL server management studio.
Follow below steps to attach a mdf file with the help of SSMS:

1. Connect to the SQL server instance using SSMS
2. From the Object Explorer, right click the Databases node and a drop-down menu will be appeared.
3. Now click on the Attach tab.
4. Click on the Add button from appeared dialog box.
5. Now a Locate Database Files dialog box will be appeared.
6. Click on the browse button to select your database MDF file after choosing .mdf file click on the OK button.
7. Now you will see your mdf file is selected but SQL server is unable to select your transaction log file because transaction log file was deleted. To attach .mdf file without transaction log file; select the log file and click on the remove button to remove it. Now click on the OK button to attach the database file. SQL server will create a transaction log file for you while attaching the database.

Resource Link: http://sqldbfriend.blogspot.in/2013/02/need-to-attach-mdf-file-without.html

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

If you want to repair .mdf file then I suggest you to use SQL recovery software which is a perfect tool for repairing entire database of .mdf file and .ndf files such as tables, triggers, stored procedures, columns and index etc. Get more information: http://www.sqldatarecovery.net/

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

RecoveryFIX for SQL Database Recovery retrieves all data stored within SQL server .MDF files such as tables, triggers, views, stored procedures with damaged unique keys, primary keys and foreign keys. For more information visit here:

http://www.repairsqlserver.net

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

There is no need of any kind of mdf repair software for this purpose. According to Raja, data was stored in the .mdf and he wants to recover data from mdf. He can easily recover data from the mdf file by attaching to the SQL server. I think you are misguiding the user. If you have posted for the link only then its Ok.

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

This tool efficiently recovers entire MDF files including triggers, tables, keys, procedures, indexes. It automatically rebuilds a new database MDF file making it the best tool among many others in the market.

Read More Info:- http://www.filesrecoverytool.com/sql-database-repair.html

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

Use Kernel for SQL Database Recovery Software and recover corrupt and delete tables, views, sql server etc in few steps. Software support multiple MDF file recovery option and Software is supported by all sql server version. Download free trial version from - http://www.sqldatabaserecovery.org/

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

How can i recover the tables which was stored in database from .mdf

Check this out ( http://www.diskinternals.com/mssql-recovery/ )

how can i see total no of databases in the server.

select COUNT(*) from sysdatabases or select COUNT(*) from sys.databases 

From : http://www.sqlservercentral.com/Forums/Topic401516-463-1.aspx#bm816566

--
Thanks & Regards,
RNA Team

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

Hi
Using Backup and Restore your database daily morning particular time thats better for your application.

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

Hi
refer this url
https://msdn.microsoft.com/en-us/ms187048.aspx
https://technet.microsoft.com/en-us/library/ms191239(v=sql.105).aspx
http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator