Home Forums SQL Server 2008 SQL Server 2008 - General How to copy the database from external server to my local system server through Stored Procedure RE: How to copy the database from external server to my local system server through Stored Procedure

  • Hi Sean Lange,

    Thank you for your reply.

    In my client place, to take backup of the database, in SQL server, there is an option 'Generate Scripts' which is not allowed at the client system. That is why I am using the stored procedure to create the backup of the client database in the client system and the same will be stored into my system through external server. In the client place, there is no network.

    I tried the scripts to connect the remote server through linked server but it is not connected.

    Is there any other way to get the backup of the database to be imported into my SQL server system or is there other options to move/copy the client database from the external server to my local server.

    Please help