MS SQL Database Backup file manager

Navigate to: Main Menu > MS SQL > Databases > Select a database > Click the Backup file manager tab.

This interface allows you to manage the files in your database's dedicated backup storage area. This is a "staging" location separate from your web server, specifically used for holding data files and scripts before they are processed by the database engine.

1. The Workflow (Import & Export)

This manager is the central hub for all data movement operations:

• Importing (Restore/Attach/Scripts): While the Restore, Attach, and Run scripts tabs allow you to upload files directly during execution, we strongly recommend uploading large files here first.
  Using the File Manager separates the file transfer from the database operation, ensuring that connection timeouts do not interrupt critical tasks like restoring a large .bak file.
• Exporting Data: This folder serves as the destination for all data retrieval operations.
  • Backups: When you generate a full backup, the .bak file is saved here.
  • Raw Data: When you use the Get database files tab, your live .mdf and .ldf files are detached and saved to this location.
  Once the files appear in this list, you can download them to your local computer.

2. Uploading Files

This tool uses high-performance streaming technology. Click the specific icon in the toolbar to open the upload zone:

• Standard Upload (Up Arrow): Drag and drop your .sql scripts or .bak files here.
• Upload Archive (Box with Up Arrow):
  Highly Recommended for Backups. Compressing a large SQL backup (e.g., 500MB) into a .zip file (e.g., 50MB) saves upload time. When you upload the archive here, the system automatically extracts the content into the folder, ready for use.
• Upload from URL (Chain Link):
  If your backup is stored on another server (like Dropbox or S3), use this to transfer it directly to our server, bypassing your local internet connection.

3. How to Select Files

• Single File: Click the row to select it.
• Multiple Files: Hold Ctrl + Click to select specific files, or Shift + Click to select a range.
• Folders: Click the text name to open the folder. Click the whitespace to the right of the name to select the folder itself.

4. Downloads & FTP

• Smart Download: Select a single file to download it directly. Select multiple files to automatically download them as a ZIP archive.
• FTP Access: The blue banner at the top displays the dedicated FTP address for this folder, allowing you to use third-party clients (like FileZilla) for file transfer if preferred.