Beginning with Version 4.5x, back up and recovery of a single table is available with LiteSpeed.
Table backup, using bcp is available in the MMC module of LiteSpeed.
Expand the LiteSpeed Management Console branch in the console tree.
The Tables folder (expand the tree under a server | Databases | [database name] | File Groups | [file group name] | Tables).
The Views folder (expand the tree under a server | Databases | [database name] | Views).
Right click to display the context menu, select Backup Assistant.
From commandline:
bcp "Northwind".dbo.Categories out "D:\Backup\Categories_table_new" -n -SALV201111 -T -q
ALV201111 being the server name.
NOTE: bcp is a SQL Server native tool, the resulting backup file will not have compression or encryption.
To Restore a single table:
In LiteSpeed Enterprise Console | Right click on the database | Object Recovery | Tables (or Schema)
In Query Analyzer:
exec master..xp_objectrecovery
, @FileName='D:\Backup\Northwind200711010555_Full.BKP'
, @ObjectName='dbo.Customers'
, @DestinationServer='ALV201111\instance_name'
, @DestinationDatabase='database_name'
, @DestinationTable='Customers_temp'
, @TempDirectory='D:\Backup'
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center