Remtoe SQL Server backup on local server using SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Remtoe SQL Server backup on local server...

Remtoe SQL Server backup on local server using SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

beejug1983

Posted Wednesday, September 09, 2009 10:15 PM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:18 AM
Points: 264, Visits: 1,288

I am trying to create a package that would take remote sql server backup on my local server. But all efforts went in no-result. Does anyone has any idea to create the same package ?
Thanks in advance...

Post #785481

vishal.gamji

Posted Thursday, September 10, 2009 7:19 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 6:37 AM
Points: 536, Visits: 477

Do u have permissions to take backup on the other side?

Post #785665

beejug1983

Posted Thursday, September 10, 2009 9:05 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:18 AM
Points: 264, Visits: 1,288

Yes I have full permission.

Post #785766

« Prev Topic | Next Topic »

Permissions