Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup using litespeed but database is present on another server Expand / Collapse
Author
Message
Posted Thursday, August 12, 2010 4:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 29, 2010 4:49 AM
Points: 1, Visits: 12
Hi,

I want to create SQL Job to backup SQL Server database using Litespeed. Database is present on a different SQL Server where Litespeed is not installed. I know how to do it using Litespeed Enterprise Console but not able find any SQL Script for the same. Litespeed backup Stored procedure xp_backup_database doesn’t accept Servername where database is present. Please let me know if it can be done using Litespeed or I need to install Litespeed on database server to backup database.

Thanks.

Post #968063
Posted Friday, August 13, 2010 3:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, November 2, 2014 3:54 AM
Points: 225, Visits: 475
I've never used light speed as such but used redgate and according to it... you can only backup & restore databases on the instance where redgate has been installed..... and assuming this it shud be same for light speed also.

Lest wait for others to post their opinion.

Rohit
Post #968764
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse