Hi gurus can anyone give me the script to restore a database in litespeed. Timely help will be appreciated. Thanks.
Example master.dbo.xp_restore_database @database='dbname', @filename='\servershareackup.bak' , @with = 'replace', @with = 'restart', @with = 'MOVE "dbname_Data" TO "D:MSSQLdatadbname_Data.MDF"', @with = 'MOVE "dbname_Log" TO "F:MSSQLTXLOGdbname_Log.LDF"' This assumes you're over-writing an existing database.