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:
01301737
Views:
14
>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.

From SSMS I don't see where can I specify the backup path. It doesn't seem it allows to change it.
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