Dashboard Shop Ask a question
Log in
Knowledge base
Introduction User Interface description How to Register a new account Paying for a purchase Keep your free account active Create a website Manage website Upload website content How to deploy Web project from Visual Studio Add a domain to your web site Manage default docments Grant write, modify, delete access rights on website's folder Upgrading from free to paid hosting Host a Non-English website Deploy MS SQL database Create an empty MS SQL database Manage MS SQL database Run SQL script Backup database Restore database Attach database Get database files Connect to database Manage backup location List database tables MS SQL Database connection string Upgrading from free to paid MS SQL hosting Manage email Add mail domain. Add SMTP account Add Mailbox Add MX record Setup mail client Create a Virtual Dedicated Server (VDS) Manage virtual server Access virtual server remotely Access virtual server with ESXi vSphere Client Virtual server upgrade Virtual server DNS management Pointing a domain name to your Virtual Server Manage your SSL certificates Free SSL certificates Export SSL certificate Bind free SSL certificate to a website on Windows VPS Troubleshooting Web site errors General HTTP errors 500 Internal Server error for all ASP pages 404.17 Not Found. The requested content appears to be script and will not be served by the static file handler This page isn’t working (HTTP ERROR 500) in ASP.NET Core app ASP.Net Errors Library not found Scripts written with ASP.NET version 2.0 or higher return errors. I have uploaded files, but it showing “Site under construction” Session variables expire irregulary One of your services has been disabled because it used as a file storage MS SQL errors The media set has x media families but only 1 are provided Enterpise Manager connection hangs or has delayed response time Mail errors Unable to send email. Error: “No Server”. Unable to send email. Errors: (550) No relay, or (530) no authentication. MS Access errors Can not connect to MS Access database. Virtual servers Remote Desktop Connection ‘Internal Error has occurred’ What type of support provided for self-managed Virtual servers Free web hosting Why did my free MS SQL database got deleted and can I restore it? Why did my free website got deleted and can I restore it? Knowledge base Code samples MS Access Connect to MS access database usin DSN-less connection Email Sending email from ASP.Net page using local mail server Send an Email message using CDOSYS Send an Email message using CDOSYS and Google Apps mail servers Send Email via C# through Google Apps account Configuration Host a WCF service in IIS FAQs SSL FAQ Legal documents Terms of service Privacy policy Refund policy

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 2023 Doka management panel