User home
System help
Ask a question
Search help
   Help system Content Search
Article content
Attach database

Attach database is an easiest deployment option when you only have a Database files (*.mdf and *.ldf)

In "User menu" navigate to "User -> Managed products -> MS SQL -> Databases -> (Database name) -> Attach database". 

There you'll be able to select Database files that already stored in Backup location or upload new database files and attach them. You can attach both - Data file (*.mdf) and Log file (*.ldf) or just a Data file. 

In order to attach just a data file (*.mdf) without a log file, the database has to be detached cleanly - all transactions has to be committed.

Warning! There are some limitations on attached files:

- You can attach only one Data file (*.mdf) and one Log file(*.ldf)! Database spread over several data or log files are not supported. Full text catalogs cannot be attached! If you need to deploy the full text catalog you need to use Backup / Restore deployment option.

- Data and Log file sizes have to be less or equal to the values allowed by MS SQL hosting plan.

- MS SQL version of attached files has to be equal or lower than MS SQL version of database created with Doka panel.

© Copyright 2018 Doka management panel