|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Utility to read transaction logsIs there a utility to read the transaction logs for SQL Server 2000? What
about SQL Server 2005? I need to review the transaction logs for two of my databases to see if/when some table columns were altered from 'null' to 'not null'. Please let me know. Thank you. -- Thank you for sharing your knowledge Ellen,
Check out: http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html RLF Show quote "Ellen" <DBAEllen@community.nospam> wrote in message news:569B1CB6-69A3-4C38-8C59-48E53DB0DC29@microsoft.com... > Is there a utility to read the transaction logs for SQL Server 2000? What > about SQL Server 2005? I need to review the transaction logs for two of > my > databases to see if/when some table columns were altered from 'null' to > 'not > null'. Please let me know. Thank you. > -- > Thank you for sharing your knowledge Thanks , I will check them out. Any preference? Looks like Apex has a free
trial. -- Show quoteThank you for sharing your knowledge "Russell Fields" wrote: > Ellen, > > Check out: > http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html > > RLF > > "Ellen" <DBAEllen@community.nospam> wrote in message > news:569B1CB6-69A3-4C38-8C59-48E53DB0DC29@microsoft.com... > > Is there a utility to read the transaction logs for SQL Server 2000? What > > about SQL Server 2005? I need to review the transaction logs for two of > > my > > databases to see if/when some table columns were altered from 'null' to > > 'not > > null'. Please let me know. Thank you. > > -- > > Thank you for sharing your knowledge > > > I don't have a direct recommendation of one over the other since it depends.
Note that Red Gate's SQL Rescue is now free (but unsupported) for SQL Server 2000, but does not exist for SQL Server 2005. RLF Show quote "Ellen" <DBAEllen@community.nospam> wrote in message news:D93F8C7F-8525-4CC3-8726-A49347995373@microsoft.com... > Thanks , I will check them out. Any preference? Looks like Apex has a > free > trial. > > -- > Thank you for sharing your knowledge > > > "Russell Fields" wrote: > >> Ellen, >> >> Check out: >> http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html >> >> RLF >> >> "Ellen" <DBAEllen@community.nospam> wrote in message >> news:569B1CB6-69A3-4C38-8C59-48E53DB0DC29@microsoft.com... >> > Is there a utility to read the transaction logs for SQL Server 2000? >> > What >> > about SQL Server 2005? I need to review the transaction logs for two >> > of >> > my >> > databases to see if/when some table columns were altered from 'null' to >> > 'not >> > null'. Please let me know. Thank you. >> > -- >> > Thank you for sharing your knowledge >> >> >> Hi Ellen,
To let us better understand your concern, could you please let us know why you would like to read the transaction log files? Currently Microsoft does not publish an official tool or method to read transaction logs. Some third-party vendors who have licensed the file layouts from Microsft are able to develop a tool to read transaction logs. From my search, there are some compatible tools with SQL 2000 now, such as Log Explorer, however there seems no tools for reading SQL Server 2005 transaction log files. Best regards, Charles Wang Microsoft Online Community Support ====================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ====================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ====================================================== Charles,
I wanted to see which columns and when, some columns on a few tables had been changed from 'null' to 'not null'. Looking through the log was one way to find that out relatively quickly and easily if there was a tool to read it. Oracle and Informix both have log explorer tools that I have used to good advantage in the past. Thank you for your interest. -- Show quoteThank you for sharing your knowledge "Charles Wang[MSFT]" wrote: > Hi Ellen, > To let us better understand your concern, could you please let us know why > you would like to read the transaction log files? > Currently Microsoft does not publish an official tool or method to read > transaction logs. Some third-party vendors who have licensed the file > layouts from Microsft are able to develop a tool to read transaction logs. > From my search, there are some compatible tools with SQL 2000 now, such as > Log Explorer, however there seems no tools for reading SQL Server 2005 > transaction log files. > > Best regards, > Charles Wang > Microsoft Online Community Support > > ====================================================== > When responding to posts, please "Reply to Group" via > your newsreader so that others may learn and benefit > from this issue. > ====================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > ====================================================== > > Hi Ellen,
Thanks for your response and let me know your real concern. I will try to consult the product team to see if there is a possible way/plan for SQL Server 2005/2008 to do this now. If there is any response, I will get back to you and post it here. Now I recommend that you could submit a feedback to Microsoft via https://connect.microsoft.com/sql. This is a good channel for Microsoft to hear customers wishes and suggestions. If you have any other questions or concerns, please feel free to let me know. Best regards, Charles Wang Microsoft Online Community Support ====================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ====================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ====================================================== Since MS has licensed the log layouts to 3rd vendors so that they can produce
very useful tools, why don't MS publishes the layouts so that some smart people can develop better tools for free? Oracle provides the log explorer for free, which is quite valuable. -- Show quotenpoto "Charles Wang[MSFT]" wrote: > Hi Ellen, > To let us better understand your concern, could you please let us know why > you would like to read the transaction log files? > Currently Microsoft does not publish an official tool or method to read > transaction logs. Some third-party vendors who have licensed the file > layouts from Microsft are able to develop a tool to read transaction logs. > From my search, there are some compatible tools with SQL 2000 now, such as > Log Explorer, however there seems no tools for reading SQL Server 2005 > transaction log files. > > Best regards, > Charles Wang > Microsoft Online Community Support > > ====================================================== > When responding to posts, please "Reply to Group" via > your newsreader so that others may learn and benefit > from this issue. > ====================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > ====================================================== > > I am not sure if there is any marketing strategy, but I think that this is
a good idea. Could you please give Microsoft feedback via https://connect.microsoft.com/sql so that you suggestions will be routed to the product team and this feature may be included in the next release of SQL Server? Best regards, Charles Wang Microsoft Online Community Support ====================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ====================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ====================================================== Hi Ellen
SQL Server ships ::fn_dblog() which is a system function that outputs entries currently in the tlog. I've blogged a sample on how to use it a few years back (not much has chaanged) here: http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2004/11/26/37.aspx Regards, Greg Linwood SQL Server MVP http://blogs.sqlserver.org.au/blogs/greg_linwood Benchmark your query performance http://www.SQLBenchmarkPro.com Show quote "Ellen" <DBAEllen@community.nospam> wrote in message news:569B1CB6-69A3-4C38-8C59-48E53DB0DC29@microsoft.com... > Is there a utility to read the transaction logs for SQL Server 2000? What > about SQL Server 2005? I need to review the transaction logs for two of > my > databases to see if/when some table columns were altered from 'null' to > 'not > null'. Please let me know. Thank you. > -- > Thank you for sharing your knowledge It is similar to the undocument DBCC statement: DBCC LOG(<database
name>,3). However the output is hard to understand and read. Best regards, Charles Wang Microsoft Online Community Support ====================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ====================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ====================================================== I'm not getting my hopes up. Feedback has been submitted hundreds of
times over at least the last 9 years to provide a documented and supported method to read the contents of a tran log or tran log backup. I've asked for it at least 30 times going all the way back to 1998 and know of many others who have also asked for the same capability. We've been through 4 versions of SQL Server and this feature which is one of the most requested items I come across keeps getting ignored. *** Sent via Developersdex http://www.developersdex.com *** In article <O13ETK$BIHA.2***@TK2MSFTNGP04.phx.gbl>,
mho***@mssqlserver.com says... > this feature which is one of ignored or just left to 3rd party developers? <g>> the most requested items I come across keeps getting ignored. > > -- Graham (Pete) Berry PeteBe***@Caltech.edu  |
|||||||||||||||||||||||
Other interesting topics