What are the challenges you face when working across database platforms? Take the survey
Options

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?

Comments

  • Options
    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
Sign In or Register to comment.