All about Information Technology!

server

Remote Server Administration Tools for Windows 7

Remote Server Administration Tools for Windows 7 enables IT administrators to manage roles and features that are installed on computers that are running Windows Server 2008 R2, Windows Server 2008, or Windows Server 2003, from a remote computer that is running Windows 7. It includes support for remote management of computers that are running either [...]

>>

, , , ,

CentOS SSH Server Installation

You need to install the following package: su – yum -y install openssh-server Start the service chkconfig sshd on service sshd start

>>

, ,

Get a list of currently logged in users in Windows Server

To get a list of currently logged in users in your Windows Server, open a cmd console and issue the following command: query session You will get a response like this: X:\path\to\somewhere>query session SESSIONNAME USERNAME ID STATE TYPE DEVICE services 0 Disc >console my_user_name 3 Active rdp-tcp 65536 Listen   X:\path\to\somewhere>

>>

, , , , , , , , , , , ,

Backup your server files easily with rsync

If you would like to back up a directory on your server and copy only changed files to your local machine, you can use the rsync tool. Just issue the following command: rsync -vare ssh username@myserver.com:/home/username/myfiles/* /home/username/myserverbackups/ That’s it!

>>

, , , , ,

Backup SQL Server Database

To create a Full Database Backup using transact sql is simple. The following sql code does the trick: USE database_name; GO BACKUP DATABASE database_name TO DISK = ‘D:\DatabaseBackups\database_name.bak’ WITH FORMAT, MEDIANAME = ‘D_Backups’, NAME = ‘Full Backup of database_name‘; GO

>>

, , , , , ,