Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Transaction Log file

    try this,

    use master

    backup database <databasename> to <devicename>

    backup log <databasename> to <device name>

    backup log <databasename> with truncate_only

    use <databasename>

    dbcc shrinkdatabase(<databasename>,<size in mb>, TRUNCATEONLY)

    dbcc shrinkfile(<transaction log file...

Viewing post 1 (of 1 total)