sqb2mtf errrors

• 
  sqb2mtf cannot convert multiple files, nor files matching search patterns. You need to name the file explicitly.

  petey August 16, 2006 20:56

  - 0 +
• 

  petey wrote:

  sqb2mtf cannot convert multiple files, nor files matching search patterns. You need to name the file explicitly.

  
  So how do you propose converting multiple compressed files to the Microsoft Tape format? We have large database and have used the backup product to compress to 8 individual files to ship to our stand by server. Being able to split in mutiple files (with the sqb2mtf utility to restore) was one of main reason we bought two licenses from Redgate. Now we want to convert these 8 files to the microsoft tape format

  paulnxweb October 16, 2006 14:17

  - 0 +
• 
  You can do this in the following fashion:
  
  If we run the command:
  
  master..sqlbackup N'-SQL "BACKUP DATABASE [pubs] TO DISK = ''d:\pubs_01.sqb'', DISK = ''D:\pubs_02.sqb''"'
  
  You can then run
  
  sqb2mtf d:\pubs_01.sqb d:\pubs_01.bak
  sqb2mtd d:\pubs_02.sqb d:\pubs_02.bak
  
  To create the two mtf files, you can then run
  
  RESTORE DATABASE [pubs] FROM DISK = 'd:\pubs_01.bak', DISK = 'd:\pubs_02.bak' WITH REPLACE, MOVE 'pubs' TO 'd:\pubs.mdf', MOVE 'pubs_log' TO 'D:\pubs_log.ldf'
  
  Hope this helps,
  
  - James
  --
  James Moore
  Red Gate Software Ltd

  James Moore October 17, 2006 04:47

  - 0 +
• 
  thanks. that wasn't an obvious solution.... at least to me.

  paulnxweb October 20, 2006 10:39

  - 0 +

Add comment

Please sign in to leave a comment.