online restore

lculleylculley Posts: 36
edited March 19, 2010 5:23AM in SQL Backup Previous Versions
Can we do SQL 2005 online restore with red gate backups? In sql 2005 native, this would be the ability to perform a restore operation while an instance of sql server is running assuming we have enterprise edition.


  • RBARBA Posts: 152 Silver 3
    Yes, this supported. SQL Backup's syntax for this is similar to T-SQL's.
    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"'
    Robin Anderson
    Red-Gate Software
Sign In or Register to comment.