kamasat (8/29/2012)
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
You mean to say that your client does not have a network? Or that you are not on that network. Either way, scripting the database using the generate script feature is not the most efficient method of copying a database. If you are not on the clients network there really is not a lot you can do. The best option would be to generate a backup. An actual backup not a scripted t-sql batch and have the client send you the .bak file.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/