Return
-
Title
Backup replace parameter is not a recognized backup option? -
Description
The command below fails, not recognizing -W replace parameter.
sqllitespeed.exe -n Master-Full -BDatabase -T -C4 -DMaster -Ffile_name -L2 --trace
logpath="D:\litespeed\backup" -W replace master.bak -
Resolution
sqllitespeed.exe -BDatabase -T -S"your instance here" -DTodayDB -I1 -F"d:\temp\TodayDB.bak" -L2 --trace logpath="d:\temp"
From the LiteSpeed Help file:
Restore with replace (use the MOVE command):
sqllitespeed.exe -Rdatabase -T -Dmaster -FC:\litespeed\backup\full\master.bak -WREPLACE -W"MOVE 'master' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\master.mdf'" -W"MOVE 'master_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\master_Log.ldf'"