How can we help you today? How can we help you today?

Convert Red Gate Compressed Tlog back to SQL native

Is there a way to do that? if so what are the instructions?
pchee373
0

Comments

1 comment

Sort by
  • petey
    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.
    petey
    0

Add comment

Please sign in to leave a comment.