📝 Overview
SQL Server is the database engine that the software runs on. Occasionally, an older version of SQL Server may need to be upgraded to keep the software running smoothly. This article explains when an upgrade is needed, how to back up your database beforehand, and how to get help completing the upgrade.
🛠️ Before You Begin
This article applies if you have been advised that your version of SQL Server needs to be upgraded, or if you are running into issues related to an older version.
Always back up your database before any upgrade work begins.
💾 Backing Up Your Database
Learn how to back up your database before upgrading SQL Server.
Open the software on your server (primary/main) computer and select File > Backup and Restore > Backup Database.
Save this backup to a location that is easy to find again, such as your desktop.
Close the software on all computers in your network.
📞 Getting Help with Your Upgrade
Once your database is backed up, upgrading SQL Server should be completed with help from the DaySmart support team. This ensures the upgrade is done correctly for your specific version and computer or server setup.
⚠️ Avoid outdated installers: Do not attempt to upgrade using an old installation file you may have downloaded previously. Our support team will make sure the correct upgrade is applied for your setup.
Visit our Support Options article to find the best way to reach our team:
❓ Frequently Asked Questions (FAQs)
Find answers to common questions or additional details that may not be covered in the main instructions.
Why does SQL Server need to be upgraded?
Click the arrow to view the answer
Click the arrow to view the answer
Older versions of SQL Server can sometimes run into problems or stop working smoothly with the software. Upgrading to a more recent version helps keep everything running reliably.
Why can't I upgrade SQL Server myself?
Click the arrow to view the answer
Click the arrow to view the answer
A SQL Server upgrade depends on your specific version and computer or server setup. Our support team completes the upgrade with you to make sure it is applied correctly.
Will I lose any data when SQL Server is upgraded?
Click the arrow to view the answer
Click the arrow to view the answer
Your data is preserved during a properly completed upgrade. Backing up your database beforehand adds an extra layer of protection in case anything needs to be restored.
What should I do before upgrading?
Click the arrow to view the answer
Click the arrow to view the answer
Back up your database and close the software on all computers in your network. See the Backing Up Your Database section above for the steps.
How do I get my upgrade started?
Click the arrow to view the answer
Click the arrow to view the answer
After backing up your database, reach out to our support team using the Support Options link above and they will help you complete the upgrade.