Attach Database

 

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

 

  1. 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

 

  1. SQL Server Management Studio
  2. SQL Tools