Create a maintenance backup plan in SQL Server 2016 R2

    Posted in Windows Servers on Jan 05, 2019

    When you create a maintenance backup plan in SQL Server 2016 R2, you must identify how you want the plan to be set up. In this example, the maintenance plan is set up with full backups, differentials, and transactions logs.

    Check SQL Server Agent service

    Verify that the SQL Server Agent service is running and set to automatic. The maintenance plan depends on this service to run.

    1. On the server, open the Run dialog box, type in services.msc and press Enter.
    2. Find the SQL Server Agent service in the list and double-click it.
    3. Click the Recovery tab and set the failure value to Restart the Service....
    [Read more...]

    How to manage csf via command line in linux server

    Posted in Linux Servers on Jan 02, 2019

    We can install the csf firewall to secure the Linux servers. We can manage the firewall via command line easily. Please read our the following article and command structure.

    Start the firewall rules
    Csf -s

    Example: #csf -s

    Flush/Stop firewall rules (note: lfd may restart csf)
    csf -f

    Example: #csf -f

    Restart the firewall rules
    csf -r

    Example: #csf -r

    Deny an IP and add to /etc/csf/csf.deny
    csf -d 

    Example: #csf -d 103.129.97.14

    Flush all IPs from the temporary IP entries
    csf -tf

    Example: #csf -tf

    Remove an IP from the temporary IP ban or allow list
    csf -tr

    Example: #csf -tr 103.129.97.14

    All...[Read more...]

    Wishing you and your family a Merry Christmas

    Posted in Linux Servers on Dec 24, 2018

    We would like to make the better use of this opportunity and congratulate our partners, who are benefited from our work. Hope for a better performing season in the new year.

    christmas.jpg

    [Read more...]

    Christmas Offers on Cloud Hosting and Dedicated Servers

    Posted in Windows Servers on Dec 23, 2018

    Christmas Offers on Cloud Hosting and Dedicated Servers get 10 % discount.

    CloudTechtiq is providing the best cloud solution with 24x7 tech support services.

    Christmas Offers.png

    [Read more...]

    How to remove emails from the queue in Plesk

    Posted in Plesk Control Panel on Dec 06, 2018

    There are two ways of doing this:

    1.Use Plesk interface: Tools & Settings > Mail Server Settings > Mail Queue > Clear 
    
    2. Connect to the server via SSH and use command-line utility:
    
    usr/local/psa/admin/sbin/mailqueuemng --clean
    [Read more...]

    Smarter Mail Recommended SPAM Settings by Cloud Techtiq

    Posted in Smarter Mail on Nov 23, 2018

    it’s important to remember that spam administration is not a "fire and forget" task. Using these built-in options requires constant tweaking to keep that level of effectiveness, and mail administrators will need to monitor incoming and outgoing spam as spammers frequently change their tactics.

    SmarterMail comes equipped with several industry-standard antispam options that can block up to 97% of all spam from entering or leaving the server and help keep mail systems running smoothly, including SPF, reverse DNS, greylisting and more. And this is done by the Message Sniffer and Cyren Premium Anti...

    [Read more...]

    How to install the Hyper-V role in Windows Server

    Posted in Windows Servers on Nov 23, 2018

    Before you build a virtualized environment you will need to install and configure the Hyper-V role on your Windows 2012 or Windows 2012 R2 server with the help of Server Manager.

    Follow these steps:-

    Step 1. Open Server Manager

    Server dashboard 1.png

    Step 2. Add roles and Fetaures

    There are 2 ways to add roles and features on Server Manger.

    Clicking on Add roles and features on the Dashboard.

    Selecting Add Roles and Features in the Manage drop down menu.

    On the Before you begin, click ## Next.

    Server roal install 2.jpg

    Step 3. Select installation type, and click ## Next

    Server roal install 3.png

    Step 4. Select Destination Server, and click ## Next

    Server roal install 4.png

    On the Sele...

    [Read more...]

    How to export import a MySQL database via SSH

    Posted in Linux Servers on Nov 16, 2018

    In this article, we will cover exporting and importing a database via SSH. Make sure that you replace the following variables in the commands below:

    USERNAME - the MySQL user assigned to your database.

    DATABASE - the name of your MySQL database.

    Exporting a MySQL database

    To export a MySQL database, you need to use the mysqldump command. Here is the full command for exporting your database:

    mysqldump -uUSERNAME -p DATABASE > backup.sql

    You will be prompted for a password - this is your MySQL user's password.

    The MySQL database will be exported to a file named "backup.sql" in your current direc...

    [Read more...]

    How to Schedule a Backup of All MySQL Databases on Ubuntu

    Posted in Linux Servers on Nov 16, 2018

    Step 1: Create the Backup Script

    Create a folder to store your backup script in. I suggest /scripts for this example: sudo mkdir /scripts

    Create a file called mysql-backup.sh inside the scripts folder:

    sudo vim /scripts/mysql-backup.sh

    Add the following code to the file and save it:

    #!/bin/bash
    #----------------------------------------
    # OPTIONS
    #----------------------------------------
    USER='root'       # MySQL User
    PASSWORD='webdev' # MySQL Password
    DAYS_TO_KEEP=0    # 0 to keep forever
    GZIP=1            # 1 = Compress
    BACKUP_PATH='/backups/mysql'
    #----------------------------------------
    
    #...
    [Read more...]

    How to Schedule a Backup of All Websites Hosted on Ubuntu

    Posted in Linux Servers on Nov 15, 2018

    Step 1: Create the Backup Script

    The first thing we need to do is create a simple backup script that will backup websites located in /var/www. The script will change into the directory and then loop through archiving each folder into /backups/www. It will also be able to cleanup backups older than X days.

    Create a folder to store your backup script in. I suggest /scripts for this example:

    sudo mkdir /scripts

    Create a file called www-backup.sh inside the scripts folder:

    sudo vim /scripts/www-backup.sh

    Add the following code to the file and save it:

    #!/bin/bash
    #---------------------------------...
    [Read more...]