SQL Server database files. Export of MDF and. MDS

1. Open your manager--Select your database--Select All Tasks--> Detach the Database--and then copy it to someone else, then you add your database.

2. Copy the location of the copy database: You can view the location of the database by clicking on the server--right-click and attach--add above

Copy after knowing where the database is located

3. The database is copied and appended to the database by the second step. This allows the database to be used again.

The database can also be attached to another server's database through the second step to facilitate connectivity to redeploy the Web site or software.

SQL Server database files. Export of MDF and. MDS