I have a database stored on the client server. I have access only the connection string of this database, so I can manage it, how can I back up the bd on the Server to My Local machine , for testing? / p>
I have a database stored on the client server. I have access only the connection string of this database, so I can manage it, how can I back up the bd on the Server to My Local machine , for testing? / p>
If you already have SQL Server running on your local machine an output is to use the SQL Server Import and Export Wizard to import the remote tables to your local instance.
Select the remote server as Source and your local machine as Destination. A detailed step-by-step can be found here at . Since I do not have SQL Server installed here at the moment, I can not go into more detail, but the steps are similar the screens of this response .