Backup using litespeed but database is present on another server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Backup using litespeed but database is...

Backup using litespeed but database is present on another server

Rate Topic

Display Mode

Topic Options

Author

Message

atul_purwar

Posted Thursday, August 12, 2010 4:55 AM

Forum 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

Ramji29

Posted Friday, August 13, 2010 3:58 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, August 31, 2012 7:19 AM
Points: 225, Visits: 419

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 »

Permissions