Silkroad SQL Server Database Backup and Automatic Scheduling (Backup)
In Silkroad private servers, all player accounts (ACCOUNT), character information (SHARD) and game logs are stored in the SQL Server database running on Windows Server. It is the most important duty of server owners to take regular database backups against the risk of a possible system failure or cyber attack on the server. In this guide, you will learn how to take a manual backup and connect it to an automatic schedule.
Method 1: Taking a Manual Backup via SQL Server
Before bringing a new update to the server or running a query on the database, make sure to take a manual backup with these steps:
- SQL Server Management Studio (SSMS) Open the program and connect.
- From the left menu, select the database you want to back up (Ex:
SRO_VT_SHARD) right click on it. - tasks -> BackUp... Follow your path.
- In the opened window destination Check the folder path where the backup will be saved (Usually C:\Backup). If there is an old backup, select it from the list, click "Remove" and click the "Add" button to give it a new file name (Ex: shard_backup.bak).
- OK Complete the backup process by pressing the button. Same process
SRO_VT_ACCOUNTRepeat for .
Method 2: Automatic Daily Backup Plan (Scheduling) with SQL Server Agent
To make sure you don't forget to take a backup every day, you can have SQL Server do this automatically every night:
- Located at the bottom of the SQL Server left menu SQL Server Agent Activate the service by right-clicking on it and selecting "Start".
- jobs right click on the folder New Job... Select the option.
- General In the tab, enter "SRO_Automatic_Backup" in the name.
- Steps Go to the tab New... Press the button. In the command field that opens, write the SQL Query code that will make the backup and save it.
- Schedules by switching to the tab New... say. Here, determine at what time (e.g. 03:00) the backup will be taken every night. Now your server will automatically take a backup in .bak format at the time you specify.
This article is specially prepared for PvPServer.
