Convert Red Gate Compressed Tlog back to SQL native

pchee373pchee373 Posts: 13
edited April 17, 2008 10:40PM in SQL Backup Previous Versions
Is there a way to do that? if so what are the instructions?
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    Via T-SQL e.g.
    EXEC master..sqlbackup '-sql "CONVERT ''e:\backups\pubs.sqb'' TO ''e:\backups\pubs.bak'' " '

    or if encrypted
    EXEC master..sqlbackup '-sql "CONVERT ''e:\backups\pubs.sqb'' TO ''e:\backups\pubs.bak'' WITH PASSWORD = ''<password>'' " '

    Via the sqb2mtf command line utility e.g.
    sqb2mtf e:\backups\pubs.sqb e:\backups\pubs.bak
    or if encrypted
    sqb2mtf e:\backups\pubs.sqb e:\backups\pubs.bak <password>
    Via a GUI, see details here.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.