Recover tables,Views, Sql Server

Posted by Raja_89 under Sql Server on 2/23/2013 | Points: 10 | Views : 1574 | Status : [Member] | Replies : 13
Hai Techie

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

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




Responses

Posted by: Pandians on: 2/23/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
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

Posted by: Raja_89 on: 2/25/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Pandians on: 2/25/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
- 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

Posted by: Markmohan on: 2/27/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Addisionphilip on: 3/15/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Henrydesouza on: 5/13/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Davegee on: 5/21/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Addisionphilip on: 5/21/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Dianabacon on: 1/2/2015 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Johanmark25 on: 3/27/2015 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Rajnilari2015 on: 3/31/2015 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
0
Down
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

Posted by: Jayakumars on: 5/8/2015 [Member] [MVP] Bronze | Points: 25

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

Mark as Answer if its helpful to you

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

Posted by: Jayakumars on: 5/8/2015 [Member] [MVP] Bronze | Points: 25

Up
-1
Down
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

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

Login to post response