6080Re: MUGH-SQLCON Re: command to read fronm ldf file which transactions were done in sql 2000
- May 8, 2008Reading transaction log is not a general practice otherwise Microsoft would have already provided a built in tool for this, though there are tools provided by ISV's but the point here is what is exact requirement? Until and unless we are clear with a problem scenario our recommendations might go wrong.
Now coming to CDC, this is a feature in SQL Server 2008 and as we know this product is still under CTP and not released to enterprise customers, RTM release is planned some time in Q4, 2008.
CDC is mainly focused for enterprise customers for data warehouse ETL scenarios where you expect change in dimensions of Type-2 and Type-3 or data during ETL, please read http://download.microsoft.com/download/8/b/2/8b22991f-3f2f-4cea-b2ba-55c190841145/SQL2008IntroDW.docx and see what Gopal Ashok (Program Manager, Microsoft SQL Server 2008 CDC group), Sunil Agarwal, T.K. Anand (Analysis Services Lead PjM) says. CDC can be used in other vital scenarios but whatever you have described below can be also achieved with AUDITING features in SQL Server 2008 up to an extent, but again it is of no use for them who are really not using that product version.
What I am trying to simply say is that we should always first understand the product used then problem scenario and then resolution steps if we can give.
Madhu K Nair <madhuotp@...> wrote:
What i meant to say was, why he or she need to read the TL? It may be
for auditing / or to find malpractice or to get the data back which
was wrongly updated. If this is the requirement, if you configure CDC
you have log who and what time what transaction and what was the data
changed (history) every thing available in the log table. Its may
not help you to read TL directly but it solve your purpose.
I hope it make sense
--- In email@example.com, Kuldeep Chauhan <mrkuldeepchauhan@...>
>know what and why she need to read log files?
> Hi Madhu,
> How CDC will be helpful in Kanchan's case when we really don't
>file? We may be able to help you.
> Tell us the exact requirements you have to read data from log
> Madhu K Nair <madhuotp@...> wrote:
> No you cant get useful information from TL using TSQL
> are few undocumented dbcc command but it will not help much. AsSQL
> already mentioned there are third party tool which does this. In
> Server 2008 there is a new feature called CDC (change data capture)Try it now.
> which is meant to track and keep the history of data changes in a
> --- In firstname.lastname@example.org, kanchan verma <kanchanvrm@> wrote:
> > Hi
> > Can i get a command to read fronm ldf file which transactions
> were done
> > regards
> > ---------------------------------
> > Download prohibited? No problem. CHAT from any browser, without
> > [Non-text portions of this message have been removed]
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
> [Non-text portions of this message have been removed]
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[Non-text portions of this message have been removed]
- << Previous post in topic Next post in topic >>