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.
| Author |
Topic |
|
naschbac
Starting Member
2 Posts |
 Posted - 2007-02-20 : 18:39:42
|
| Hi,There was an issue with a site that went life for us where some inserts of customer data were failing due to differences in configuration of the DB between our staging and production environments.I was hoping there would be a way to recover at least the Query strings for the attempted INSERTs that failed so that I could extract the data I need from the Queries themselves.Do any of the logs for MS SQL Server 2000 store this kind of information? Is there anywhere else I might be able to extract that info? The queries were being run from an ASP.NET 1.1 web application if that offers any helpful info.Any ideas?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-20 : 18:46:22
|
| If your database recovery model is set to FULL or BULK-LOGGED, then the information will either be in the current LDF or in your transaction log backup. You can use your tlog backup to restore to a point in time. You could also purchase a third party tool such as Lumigent's Log Explorer to read the transaction log to get those statements. Red Gate has a similar tool too.If, however, your database recovery model is set to SIMPLE, then you are out of luck.Tara Kizer |
 |
|
|
naschbac
Starting Member
2 Posts |
Posted - 2007-02-20 : 20:07:11
|
| Thanks for the quick reply.Unfortunately getting information like that is part of the problem.The DB is being hosted by Verio as part of their shared hosting package.I'm in the process of trying to get someone over there to get me the transaction log. Do you know of any way through Enterprise Manager, or otherwise, to figure out what the recovery model is set to? Keeping in mind that at the moment I don't have any kind of elevated privileges to the data-store. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-20 : 23:05:12
|
| You just need to right click on the database, go to properties, then to Options tab.Tara Kizer |
|
|
|
|
|
|
Recovering SQL Queries for failed INSERTs