Category: Cloud & Virtualization

CSF Installation

great article.

Linux - Windows Web Hosting & Server Issues

 

To install csf simply do the following from the root shell via SSH:

cd /usr/local/src
wget http://www.configserver.com/free/csf.tgz
tar -xzf csf.tgz
cd csf
sh install.sh

You will have to edit csf.conf file. It’s located here: /etc/csf/csf.conf

You need to change the Testing mode.

Testing = “0″

And you need to configure open ports in csf.conf or you won’t be able to
access these ports. In most cases it should be configured like this if
you are using cPanel/WHM. If you are running something on some other port
you will have to enable it here. If you changed SSH port you will have
to add a new port here:

# Allow incoming TCP ports

TCP_IN = “20,21,22,25,53,80,110,143,443,465,587,993,995,207 7,2078,2082,2083,2086,2087,2095,2096″

# Allow outgoing TCP ports
TCP_OUT = “20,21,22,25,37,43,53,80,110,113,443,587,873,2087, 2089,2703″

CSF Connection Limit:

There is in csf.conf CT option, configure it like this
CT_LIMIT = “100″ ( It means every IP with more than…

View original post 110 more words

Advertisements

SQL Server SIMPLE Recovery Model Step by Step Tutorial with Examples

How to Change Database Recovery Model to SIMPLE Using SSMS

  • Connect to SQL Server Instance using SQL Server Management Studio
  • Expand Database Node and then right click the user Database and select Properties from the drop down menu
  • Click Options Page on the right side pane as highlighted in the below snippet
  • Under Recovery Model choose SIMPLE and click OK to save.

 

How to change the recovery model of SQL Server Database Using SSMS

 

https://www.mytechmantra.com/SQL-Server-Tutorials/SQL-Server-SIMPLE-Recovery-Model-Tutorial-with-Examples/

Backup and Restore Resource Database in SQL Server

Introduction

Microsoft SQL Server 2005 introduced a new system database namely Resource database. It’s a read-only system database which is hidden from users and in this article we will discuss how to backup and restore Resource Database in SQL Server. DBA should backup Resource Database along with other System Databases in SQL Server as part of Disaster Recovery and most importantly document the location of each and every system and user databases.

 

https://www.mytechmantra.com/LearnSQLServer/Backup-and-Restore-Resource-Database-in-SQL-Server/