Configuration of 1C server + SQL (optimization, security, backups)
Looking for an experienced 1C / MS SQL administrator for server setup and optimization.
Current situation:
- Windows Server 2019
- 1C + MS SQL
- about 60 users (RDP)
- physical server (local)
- several disks are used, including NVMe (Samsung 980 PRO)
What needs to be done:
1. Check and restore RAID (currently there is an error "failed redundancy")
2. Analyze the current disk structure and optimize:
- move SQL database to fast NVMe
- proper placement of TempDB and logs
- exclude slow disks from 1C operation
3. Optimize MS SQL for 1C:
- configure TempDB (number of files and placement)
- configure RAM usage
- basic performance optimization
4. Set up a backup system (CRITICAL):
- FULL / DIFF / LOG backups of SQL
- automate all processes
- mandatory backup storage in several locations:
• locally
• on a separate medium (second disk / NAS)
• in the cloud (S3 / Backblaze / similar)
- check recovery (test restore)
5. Set up server redundancy:
- create an image (backup image) of the entire system
- ability to quickly restore the server "as is"
- minimize downtime in case of failure
6. Set up security:
- close direct access to the server (RDP)
- configure VPN (WireGuard)
- basic firewall setup
7. General server check:
- identify bottlenecks
- recommendations for performance improvement
Important:
- need a specialist with experience specifically in 1C + SQL
- important to do it without data loss
- it is desirable to minimize system downtime
- critically important to properly set up backups and recovery
Expected result:
- acceleration of 1C operation
- stable operation without freezes
- configured and verified backups (in several locations)
- presence of a complete server image for quick recovery
- secure access to the server
In the response, please indicate:
- experience with 1C and SQL
- examples of similar projects
- what steps you propose for optimization and backups
-
6300 172 0 Hello! My name is Mikhail, I am a system administrator with over 20 years of experience.
📌 I have reviewed your task — Setting up a 1C + SQL server (optimization, security, backups). I have extensive practical experience in performing similar tasks. You can find feedback on similar projects in my profile. I am ready to start working on the task immediately after discussing the technical details and the payment amount.
Is the server just a powerful computer or is it a vendor server with the ability to connect via KVM, iLO, iDRAC, etc.? Is the server located in the office or in a data center? What is the internet channel speed?
In your response, please indicate:
- experience with 1C and SQL - yes
- examples of similar projects - in the profile
… - what steps you propose for optimization and backups - this will be after the audit
✅ The work will be completed promptly and with high quality.
✅ Guarantee — 10 days after the completion of the work.
✅ Support if necessary.
🔗 Examples of completed projects:
Freelancehunt
💼 My skills:
Server setup and maintenance
Virtualization: VMware, Hyper-V, Proxmox
Windows / Linux Server installation and configuration
MSSQL Server
1C:Enterprise, M.E.Doc, Bitrix
LAMP / LEMP stacks, SSL certificates
Mail servers: Postfix, Dovecot, Roundcube, SPF, DKIM
Monitoring system Zabbix
Cloud storage, FTP servers
Backup, replication
Network equipment setup: VLAN, VPN, Wi-Fi
"Quality is doing it well even when no one is watching."
Sincerely,
Mikhail
-
594 6 0 I do such projects and take them for maintenance constantly, currently maintaining 8 1C servers and one server at the handover stage. I have a diploma and a certification exam in 1C for Platform 8.3. I will write the plan for the implementation of your project in a private message upon request.
-
1059 13 1 Good day! I have quite a broad experience in such tasks and have clients on ongoing service with such projects. I will help you too. Write to me privately for clarification of details.
-
4602 28 0 Good day, we are ready to complete tasks quickly and in full, we provide full support and maintenance of servers and software 1C/BAS, please feel free to contact for clarifications in personal messages.
-
447 3 0 Good evening
The technical task is excellent - the task is clear, I have encountered this more than once
Experience: I have been administering 1C + MS SQL for over 6 years, worked with loads from 20 to 150 users on RDP, physical servers are my usual environment
What I propose in order:
* RAID: diagnostics, recovery of redundancy without data loss (if the controller allows - online, if not - we will agree on a window)
* Migration of the database to NVMe + proper separation of TempDB and logs - this significantly speeds up 1C, especially with 60 users
… * SQL optimization is done for a specific load profile, not by a template from the internet
* Backups: I will set up FULL/DIFF/LOG, export to several locations (locally + external storage + S3/Backblaze), necessarily with a test restore - without this, a backup is not considered
* I will set up WireGuard + firewall, we will close RDP to the outside
Deadline: 2-3 working days (including backup testing and documentation)
For a simple system - minimal, we will agree with you in advance
Cost: 14,000 – 16,000 UAH fixed
The only exception - if RAID requires non-standard intervention, we will discuss this separately and in advance, there will be no surprises
If interested - I am ready to call, look at the current state of the server and provide a more accurate estimate :)
Current freelance projects in the category Software & Server Configuration
Migration of Windows Server 2016.Need a system administrator for the setup and migration of Windows Server 2016. Task: 1. Conduct an audit of the current Windows Server 2016. 2. Check server roles: RDP/RDS, users, access rights, network settings, firewall, backup. 3. Prepare a migration plan without data… System & Network Administration, Software & Server Configuration ∙ 1 day 19 hours back ∙ 12 proposals |
Connection of professional book scanners in OdesaConnect professional book scanners (2 units) in 2 locations in Odesa. Perform assembly according to the instructions, connection, and software setup including test scanning to a file from the program on the PC. System & Network Administration, Software & Server Configuration ∙ 1 day 20 hours back ∙ 2 proposals |
Setting up the UkrSklad programRestart (recover) the program. The program was working, but then the database crashed (all information about the product). Software & Server Configuration ∙ 4 days 14 hours back ∙ 5 proposals |
Setting up the Android environment on PC for fintech: installing an emulator/anti-detect and Nige proxyHello! I need to prepare a workstation on a PC for working with banking applications in Nigeria (fintech, mobile banking) from Ukraine. The task is technically delicate, so I am looking for a specialist with experience in traffic arbitration, bypassing anti-fraud systems, or… Software & Server Configuration ∙ 5 days 10 hours back ∙ 1 proposal |
Comprehensive check and protection of the office server + email setup
90 USD
A specialist is needed for a comprehensive check and adjustment of the server infrastructure in the office. Currently, several virtual machines on Ubuntu are running through Proxmox, with the main database and virtual machines for Laravel websites. There were previous issues… System & Network Administration, Software & Server Configuration ∙ 8 days 14 hours back ∙ 14 proposals |