• Replies 5 replies
  • Subscribers 336 subscribers
  • Views 26 views
  • Users 0 members are here
Related

Tessitura wont load - transaction log is full...

Randall Mitchell
$organization

We are unable to launch Tessi, The error is "transaction log for database impresario is full".. We had an error with our backup last night, but I dont see why that should be causing this issue.

How do I resolve this and get Tessi back online? Ideas?

Parents
  • $organization

    Hi Randall,

    1,change recovery model from 'Full' to 'Simple'

    2, shrink impresario

    3,change recovery model from 'Simple' to 'Full'

    here is the script:

    USE [master]

    GO

    ALTER DATABASE [impresario] SET RECOVERY SIMPLE WITH NO_WAIT

    GO

    ALTER DATABASE [impresario] SET RECOVERY SIMPLE

    GO

    USE [impresario]

    GO

    DBCC SHRINKDATABASE(N'impresario' )

    GO

    USE [master]

    GO

    ALTER DATABASE [impresario] SET RECOVERY FULL WITH NO_WAIT

    GO

    ALTER DATABASE [impresario] SET RECOVERY FULL

    GO

     

     

     

     

     

     

    have fun

    Ben



    [edited by: Ben Gu at 7:21 PM (GMT -6) on 5 Oct 2009]
Reply
  • $organization

    Hi Randall,

    1,change recovery model from 'Full' to 'Simple'

    2, shrink impresario

    3,change recovery model from 'Simple' to 'Full'

    here is the script:

    USE [master]

    GO

    ALTER DATABASE [impresario] SET RECOVERY SIMPLE WITH NO_WAIT

    GO

    ALTER DATABASE [impresario] SET RECOVERY SIMPLE

    GO

    USE [impresario]

    GO

    DBCC SHRINKDATABASE(N'impresario' )

    GO

    USE [master]

    GO

    ALTER DATABASE [impresario] SET RECOVERY FULL WITH NO_WAIT

    GO

    ALTER DATABASE [impresario] SET RECOVERY FULL

    GO

     

     

     

     

     

     

    have fun

    Ben



    [edited by: Ben Gu at 7:21 PM (GMT -6) on 5 Oct 2009]
Children
No Data