SQL Server Performance

Verrrrrrry Urgent

Discussion in 'Third Party Tools' started by lara99, Oct 11, 2007.

  1. lara99 New Member

    Hi gurus can anyone give me the script to restore a database in litespeed.
    Timely help will be appreciated.
    Thanks.
  2. Adriaan New Member

    Try using litespeed itself, rather than the MS tools.
  3. satya Moderator

    Check their documentation for such code exampls.
  4. thomas New Member

    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.

Share This Page