Activity overview
Latest activity by Virul
Very detailed answer. It worked for me RESTORE SQBHEADERONLY and RESTORE DATABASE db1 FROM DISK = [d:\backups\bfile_*.sqb] worked. Thanks / comments
Very detailed answer.It worked for meRESTORE SQBHEADERONLYand RESTORE DATABASE db1 FROM DISK = [d:\backups\bfile_*.sqb]worked.Thanks
Does "RESTORE LABELONLY" work with .sqb file?
Task: Redgate created bakup in split file. So i have 4 sqb files.We need to create dynamic restore script and restore db on SQL instance.I want to figure out how many sqb files backup has?, in this...
Task: Redgate created bakup in split file. So i have 4 sqb files. We need to create dynamic restore script and restore db on SQL instance. I want to figure out how many sqb files backup has?, in this case it should be 4. We are passing first sql file as parameter I am using below command EXEC MASTER..SQLBACKUP '-SQL "RESTORE LABELONLY FROM DISK = ''D:\backups\bfile_1.sqb'' It seems labelonly does not work I am getting below result. Syntax error: 'LABELONLY' after 'RESTORE' exitcode 850 sqlerrorcode 0 Any help? / comments
Task: Redgate created bakup in split file. So i have 4 sqb files.We need to create dynamic restore script and restore db on SQL instance.I want to figure out how many sqb files backup has?, in this...