Friday, April 06, 2012

How to restore database from RedGate SQLBackup Files

If you are using RedGate Sql backup to restore the database then you can use following t-sql code

EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE [AdventureWorks]
FROM
DISK = ''\\myserver\Backup\AdventureWorks_01.sqb'',
DISK = ''\\myserver\Backup\AdventureWorks_02.sqb''
WITH RECOVERY,
MOVE ''AdventureWorks'' TO ''H:\MSSQL\Data\AdventureWorks.mdf'',
MOVE ''AdventureWorks_log'' TO ''I:\MSSQL\Logs\AdventureWorks_log.ldf'',
REPLACE"'
Posted by at
Labels:

AltStyle によって変換されたページ (->オリジナル) /