User Manual for SQLBK - SQL Server Backup Service
Part 1: Configuration and Setup
1 - Open the Program
Launch the SQLBK program by double-clicking the application icon.
The main window will have a menu with a “Config” button.
2 - Click on Config in main window
Click the “Config” button to open the configuration settings for the SQLBK system.
3 - General Settings GUI
The General Settings window will display options for configuring the backup service.
4. SQL Server Setup
Enter the SQL Server connection details:
Server Name: Enter the name or IP address of the SQL Server.
Authentication: SQL Server Authentication authentication.
Username and Password: Must provide credentials SQL Server Authentication.
5. Test Connection
Click the “Test Connection” button to verify that the program can connect to the SQL Server.
A success message will appear if the connection is successful.
6. Configure Database Selection
Click the “Control Databases” button to control the list of databases from the SQL Server.
Use the checkboxes to select databases for backup:
Selected: Manually select specific databases by checking their respective boxes.
Back Up All: Check this box to select all databases.
Set output directory
7. Service Configuration
Set the following options for the backup service:
First Run: Specify the date and time for the first backup.
Time Interval: Set the frequency (e.g., hours, minutes) for automatic backups.
8. Save Configuration
Click the “Save” button to save all settings.
Part 2: Install and Run the Background Service
1. Install the Service
Click the “Install Service” button to install the SQLBK background service on your system.
2. Run/Stop the Service
Use the “Run Service” button to start the backup service.
Use the “Stop Service” button to pause or stop the service.
3. Verify the Service in Windows
Open the Windows Services Manager:
Press `Win + R`, type `services.msc`, and press Enter.
Look for the “sontecSQLBK” in the list to verify its status (Running/Stopped).
4. View Backed-Up Databases
Navigate to the backup folder specified in the configuration.
The folder will contain the backup files (.bak) for the selected databases.
Check the time after that you set before and you will see that the files has been update
