April 30, 2012 at 4:22 am
Can any one tell me whether it is possible to restore the database manually ( using TSQL) from the Litespeed backup file.(backup is done from litespeed for the database).
April 30, 2012 at 4:26 am
as long as you are restoring the backup to a server where litespeed is installed then yes, other wise you will need to use the extractor tool then use the native RESTORE DATABASE commands.
the easiest way would be to run through a restore in the GUI and one of the last steps is to preview the script it will execute, you can then copy this and modify it as you need to.
exec master.dbo.xp_restore_database @database = N'DBName' ,
@filename = N'\\SomeServer\SomeFolder\SomeFile.bak',
@filenumber = 1,
@with = N'REPLACE',
@with = N'STATS = 10',
@with = N'MOVE N''LogicalFileName'' TO N''PhysicalFileName''',
@with = N'MOVE N''LogicalFileName'' TO N''PhysicalFileName''',
@affinity = 0,
@logging = 0
GO
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply