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

Restore on a different server

I got SQL Backup last week for 2 of my 2000 servers. From this backup, I need to restore one DB to a 2005 server that does not have Red Gate backup License.

What will be my command line script to restore a full backup and diff backup to read SQL backup files?

MY regular SQL Native Backup command does not work for this red gate backup files!!

Thanks.
sam-tpcan
0

Comments

2 comments

Sort by
  • Matthew Flatt
    Hi,

    You have a couple of options for restoring the backups to your machine.

    The first would be to install the 14 day trial version of SQL Backup on your machine and use the extended stored procedure/GUI to restore it. Obviously if you need to regularly restore a backup you would end up needing a licence.

    The second option is to convert your backup file to Native format and then restore the files to your second SQL Server in the usual way.

    The command line version of the converter is called sqb2mtf and is located in your SQL Backup GUI installation folder.

    There is also a GUI Version available from :

    http://labs.red-gate.com/index.php/SQL_ ... _Converter

    You can also use the extended stored procedures to convert the file with the following :

    exec master..sqlbackup N'-SQL "CONVERT ''C:\Northwind.sqb'' TO ''C:\Northwind.bak''"'

    I hope this helps.
    Matthew Flatt
    0
  • jerryhung
    That's what I do to restore our production .sqb files

    on machines with SQL Backup, I use the
    exec master..sqlbackup

    on most of other machines I need to restore
    I use sqb2mtf, works very well
    jerryhung
    0

Add comment

Please sign in to leave a comment.