Convert Red Gate Compressed Tlog back to SQL native

pchee373 · April 17, 2008 2:25PM

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

petey · April 17, 2008 10:40PM

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 = ''&lt;password&gt;'' " '

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 &lt;password&gt;

Via a GUI, see details here.

Comments