LITESPEED restore

  • Hi,

    I am trying to restore a dababase with litespeed backup file- 13GB. I am using litespeed console and at the end of step i got error saying 'use with move option, cannot find correct location for ndf file'. I DON'T SEE WITH OPTION IN LITESPEED CONSOLE. But I could see database is in restore mode....please advice.

    below is the scriipt: Iam not able to edit this in LS console

    exec master.dbo.xp_restore_database @database = N'Comet_POSL_DM' ,

    @filename = N'F:\restored\POSLProdDB_Full_2012_22_06_000500.LSP',

    @filenumber = 1,

    @with = N'STATS = 10',

    @with = N'MOVE N''poslproddb_data'' TO N''D:\MSSQL\Data\Comet_POSL_DM_1.mdf ''',

    @with = N'MOVE N''poslproddb_log'' TO N''E:\MSSQLComet_POSL_DM_log_1.LDF''',

    @affinity = 0,

    @logging = 0

    GO

  • The Litespeed console is very similar to the standard GUI utilities in SSMS. When you get to the option for the files, you can modify the file locations.

    In the code you provided - review the WITH options and make sure you are placing the files on the correct drives.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Thanks.

    I modified the file/location and it worked. thanks again

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply