exec sqlbackup '-SQL "BACKUP DATABASE [MyDB] TO DISK = ''e:\backups\r.sqb'' WITH COMPRESSION = 4, INIT, THREADCOUNT = 3"'
exec sqlbackup '-SQL "RESTORE DATABASE [MyDB] FILEGROUP=''secondary'' FROM DISK = ''e:\backups\r.sqb'' WITH NORECOVERY"'
exec sqlbackup '-SQL "BACKUP LOG [MyDB] TO DISK = ''e:\backups\tail.sqb'' WITH COPY_ONLY, INIT"'
exec sqlbackup '-SQL "RESTORE LOG [MyDB] FROM DISK = ''e:\backups\tail.sqb'' WITH RECOVERY"'
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal
Get the latest news and training with the monthly Redgate Update