The file got corrupted . How can I retrieve the data from log files in SQL Server?

Posted By: Avi

Date: 1 October 2010 11:58:08 AM

Answer:

There are no specific commands or methods in SQL server to retrieve the data from the log files. Some external tools such as Log Explorer,SQL Log Rescue can be used to get data from log files.
Posted By: avibtech	Date: 1 October 2010 11:58:08 AM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website

Country

Notify me when new Answers are added

Enter the text as shown in the image

What is the difference between UNION and UNION ALL Statements?

UNION command selects distinct and related information from two tables while UNION ALL selects all t....

Category: SQL Server

Date: 10/7/2009 3:19:40 AM

VARCHAR is a variable length string of ASCII characters while NVARCHAR is a variable length string o....

Category: SQL Server

Date: 10/7/2009 3:09:18 AM

SQL injection is an attack in which malicious code is inserted into strings that are later passed to....

Category: SQL Server

Date: 10/2/2009 7:12:03 AM

It causes SQL Server to stop processing the query after the specified number of rows (e.g. SET ROWCO....

Category: SQL Server

Date: 10/2/2009 7:03:39 AM

Lets consider if we have a table Employee with rowid, name and email columns. Then we can use follow....

Category: SQL Server

Date: 9/19/2009 4:58:46 AM

View All Questions >>

Signup for our weekly email newsletter