none
How to view .ldf of Microsoft SQL Server 2005/2008 ?

All replies

  • There is no way that you can view the .ldf file from SQL Server but from 3rd party tool Apex SQL is very good tool.

    http://www.sqlservercentral.com/articles/Product+Reviews/2894/


    Thanks,
    Nimit

    Wednesday, June 03, 2009 12:25 AM
  • Very strange, and I see online the ldf, error
    ApexSQL Log 2008 there ApexSqlServerHelp2008 failed: OpenSCManger () failed: Access was denied

    Look at backup. BAK
    log is empty

    Database off-line to look at. Ldf is empty

    Database is MS-SQL Server 2008 with SP1


    According to a note here, there is support for SQL 2005, but did not say support for SQL 2008
    http://www.sqlservercentral.com/articles/Product + Reviews/2894 /

    Wednesday, June 03, 2009 7:47 AM
  • dbcc log (mydatabase)  is the command you want to use for that.  Depending on how big your log is you can open it as a text file but it is pretty ugly. 

    There are a bunch of functions you can do with dbcc so look it up and you might have an easier go of things.

    Monday, June 15, 2009 2:23 PM
  • Try this

    SELECT

    name,
    filename,
    size * 8.0 / 1024 AS SizeByMB,
    size * 8.0 / 1024 / 1024 AS SizeByGB
    FROM sys.sysaltfiles

    Thanks Faiz Farazi MCDBA,MCSA
    Friday, June 19, 2009 4:38 AM
  • Try this

    SELECT

    name,
    filename,
    size * 8.0 / 1024 AS SizeByMB,
    size * 8.0 / 1024 / 1024 AS SizeByGB
    FROM sys.sysaltfiles

    Thanks Faiz Farazi MCDBA,MCSA

    Above does not show at all what is inside the ldf file...

    Faiz, you might want to hold back with suggesting your own posts as answers, especially without any feedback from the original poster.
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Friday, June 19, 2009 7:16 AM