Convert Red Gate Compressed Tlog back to SQL native

pchee373

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

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.