Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Data File Restoration

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2013-01-20 : 01:49:25
Hi All,

I am having LDF file of one database which only thing got recover in Server Crash.

Please suggest how can I upload this in SQL again

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-20 : 06:04:17
If you have a backup of the database, restore it from the backup.

LDF file contains only the log records - that is not sufficient to recover or restore the database.

If the database is critical and if you don't have a backup, you might try some of the data recovery tools available - I have no experience with them, so don't know what the probability of success is.
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2013-01-21 : 03:20:01
Agree with James K,

LDF file is not sufficient to recover your corrupt database. As James K already suggested third party SQL Recovery Software to repair corrupt database. I have used Stellar Phoenix SQL Recovery Software to repair my corrupt database. Please check this link for more information about the software: http://www.stellarinfo.com/sql-recovery.htm
Go to Top of Page

venspidia
Starting Member

1 Post

Posted - 2013-02-18 : 08:04:21
To restore your corrupt sql files database just try Kernel for sql database recovery tool that recover or repair all corrupt sql files from sql database. To know more visit: unspammed
Go to Top of Page

drdesouza
Starting Member

6 Posts

Posted - 2013-04-25 : 15:11:54
Hi

You can restore it from backup file, but due to some reasons if fresh backup is not available or backup file is corrupt and damaged then use this helpful application (SQL Backup Recovery Software). With the help of this application you can restore entire backup of SQL Server database in just few seconds. If you have any problem related to run this application then visit at: unspammed
Go to Top of Page

johnpark2012
Starting Member

3 Posts

Posted - 2013-08-16 : 07:23:26
Transaction log files holds the log information, Just try now when mdf also corrupt in SQL Server 2000

sp_attach_single_file_db [ @dbname= ] 'dbname'
, [ @physname= ] 'physical_name'


Thanks

John Park
http://sqlserverrecoverysoftware.blogspot.com
Go to Top of Page

replles1
Starting Member

1 Post

Posted - 2014-03-21 : 14:23:02
Try also SQL Database Recovery Software. Free Download click here http://database-recovery.weebly.com
Go to Top of Page

elliswhite
Starting Member

36 Posts

Posted - 2014-05-05 : 00:36:07
Read this blog http://sqlcheck.blogspot.in/2013/10/how-to-perform-sql-data-recovery-and.html

Hopefully you will be able to get your database in healthy way with it.
[url][/url]
Go to Top of Page

JohnBruce
Starting Member

1 Post

Posted - 2014-08-18 : 02:05:54
If you are facing corruption issues in your SQL Server database then you can use SQL recovery software which is especially designed for corrupted or damaged MDF file that can help you to easily repair and recover SQL database such as tables, triggers, functions, stored procedures and views etc. It also provides free demo facility, so you can download this tool from here:- http://www.recoverfilesdata.com/sql-database-mdf-recovery.html
Go to Top of Page

garydossan
Starting Member

6 Posts

Posted - 2014-09-02 : 03:05:48
Use Recovery Toolbox for SQL Server database recovery tool which helps you to restore deleted SQL database. You can download this tool from here: http://www.sql.recoverytoolbox.com/[url][/url]
Go to Top of Page
   

- Advertisement -