Backup and Restore Database

----- 1: Backup Database:
BACKUP DATABASE DBName
TO DISK = '\\FilePath\BackupFileName.BAK'

GO

----- 2: Restore Database to existing database with files at same location as backup
RESTORE DATABASE DBName
FROM DISK = 'X:\FilePath\BackupFileName.BAK'

----- 3: Restore Database to new database and move files to new location
RESTORE DATABASE DBName
FROM DISK = 'X:\FilePath\BackupFileName.BAK'
WITH
MOVE 'DataFileLogicalName' TO 'X:\NewPath\DataFileName.MDF'
, MOVE 'LogFileLogicalName' TO 'X:\NewPath\LogFileName.LDF'

----- 4: Restore LiteSpeed database backup
EXEC master.dbo.xp_restore_database
@database = 'DBName'
, @filename = 'X:\FilePath\BackupFileName.BAK'
, @WITH = 'WITH MOVE "DataFileLogicalName" TO "X:\NewPath\DataFileName.MDF"'
, @WITH = 'MOVE "LogFileLogicalName" TO "X:\NewPath\LogFileName.LDF"'
, @EncryptionKey = 'EncryptionKeyValue'

** Use WITH MOVE above if needed.