Data File Restoration - SQL Server Forums

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.

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

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

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

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

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

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]

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

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]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources