SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Data File Restoration
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

228 Posts

Posted - 01/20/2013 :  01:49:25  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3589 Posts

Posted - 01/20/2013 :  06:04:17  Show Profile  Reply with Quote
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

Posting Yak Master

195 Posts

Posted - 01/21/2013 :  03:20:01  Show Profile  Visit prett's Homepage  Reply with Quote
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

Starting Member

1 Posts

Posted - 02/18/2013 :  08:04:21  Show Profile  Reply with Quote
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

Starting Member

6 Posts

Posted - 04/25/2013 :  15:11:54  Show Profile  Reply with Quote

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

Starting Member

3 Posts

Posted - 08/16/2013 :  07:23:26  Show Profile  Reply with Quote
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'


John Park
Go to Top of Page

Starting Member

1 Posts

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

Starting Member

36 Posts

Posted - 05/05/2014 :  00:36:07  Show Profile  Reply with Quote
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.
Go to Top of Page

Starting Member

1 Posts

Posted - 08/18/2014 :  02:05:54  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000