I am trying to restore a database that I backed up using SQL LiteSpeed. Since the database already exists I receive a message that I need to use the WITH REPLACE option.
Does anyone know the syntax regarding this option? I've checked SQL LiteSpeed help and it mentions this option, but fails to give an example on how to use it. The basic restore syntax is:
exec master.dbo.xp_restore_database
@database = 'dbname',
@filename = 'location of file'
Any help on how to use the WITH REPLACE option would be greatly appreciated!