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

online restore

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.
lculley
0

Comments

1 comment

Sort by
  • RBA
    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"'
    RBA
    0

Add comment

Please sign in to leave a comment.