June 23, 2012 at 10:58 pm
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
June 24, 2012 at 8:55 am
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
June 24, 2012 at 9:12 am
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