Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simplest way to copy whole database
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01301462
Message ID:
01301465
Views:
14
>>Hi everybody,
>>
>>I have a database on the test server. I also used to have a database on the local PC, but not anymore (though I found some MDB file).
>>
>>My question is - what would be the simplest way to copy the database from the test server to the local PC and how would I adjust the connection string to use it locally?
>>
>>Thanks a lot in advance.
>
>Easiest way is to detach it from test server, copy it to local one and attack it to both.
>Other way. Make a backup of the DB on the test server. Create and empty database with the same name on your local server, then restore that Backup with overwrite database.

We may try the second path, sounds good.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform