Back Office > Administration > SQL Tools > Database Maintenance > Advanced Tasks > Attach Database
Description
This menu item is used to attach a Database to the SQL Server. It is recommended to always Backup and Restore databases rather then use this method.
To Be Considered
- This feature is normally only used to attach an existing database. If the database that you are trying to attach is from a later version of SQL Server, you will get errors.
Attach Database
A Database (.MDF) file and a log (.LDF) file can be attached to the SQL Server using this screen.
- Database Name - Displays/Enter the name to be assigned to the Database being restored. The default is SWIFTPOS.
- Backup File Location - Select the Browse button to set the location path to that in which the Database file is located.
- Attach Log File - Select the to also attach a log (.LDF) file.
- Backup Information - Select the Browse button to set the location path to that in which the log (.LDF) file is located.
- Attach Now - Select to attach.
- Close - Select to exit.
Related Topics
