DFS is a method or a process to increase the consistency of Shared file server.
DFS in a Windows Server Infrastructure & DFS Replication
It’s difficult to recall all file server in Infrastructure so, Microsoft implemented Distributed file server.
DFS is a technology to manage multiple shared files from single server but actually DFS picked the data from original location.
Distributed File System- (DFS) – DFS is a Windows Server feature which allows System Administrators to create a single namespace to provide a replicated sharing infrastructure across the network.
Here I am going to explain how to install DFS in your Infrastructure.
Select which wins server you wanted to become Primary File shared server.
Go to windows server
Open windows server manager.
Click to add roles and features
Installation will be on Role Based feature-based installation
—Steps
Install Distributed File System from server Manager
Start DFS from tools
Create new Namespace server
Again, create new namespace server inside created namespace server
Create new folder inside namespace
Add folder target for replication jobs
—
Select DFS Replication and Namespace
Once selected click too next
DFS is ROLES based installation.
And roles added make all default installation.
(We need to Install DFS Roles on all File Server which will be associate with Main File Server.
Like example: I am having Primary Server I need to associate all my file server will associate with Primary server with the help of DFS ACTUALLY file server will be on his original location but they act like hosted with primary server.
)
Check the features leave as default and click too next
Now click to install
Once installation done click to tools
Now close wizard after installation done
Now click to tools and select dfs
Once DFS Wizard open click to namespace primary file server and create new namespace
Enter the host namespace server so, primary server will be hosting browse primary server
Once select server name click to next
Time the Shared file name edit permission setting click to custom permission add users and apply
Now select domain based namespace
And click to create namespace
Once done close wizard
Now adding the file server to primary server inside the created namespace
Right click on created namespace and add new namespace server
Browse file server machine name and assign permission and click to ok
Click ok Wizard
Namespace server having two now
So, now need the target folder right click and click new target folder
File Server Directory
Click to folder right click and select to folder target
Browse the target folder and select that
Once selected click okay
Replication job verification click yes
Once replication wizard change the replication name or leave as default
Now click to next
Primary member
Topology
Click to next
Now click to create replication job
Created successfully
Replication one server to another server
Now here I am checking and sharing File Server using Secondary Server (Because I don’t want to share my Primary server’s name to Infrastructure users).
Here: I am having all data to my primary server but just using to replicate and hide my primary server details to users.
Start DFS in Secondary server
Assign user permission
Domain based name space
Now click to create
Namespace created close the wizard
Right click to created namespace and create new namespace to created server
Browse server
So now here NEW namespace server creating behalf of bdc server
Namespace server status
Namespace servers
Now creating the folder
Browse the shared folder and select that
Selected folder
Click okay
Created folders
Now select the folder and add the replication target
Select the folder target
Now click okay
Now replication job will be created
Once replication started here configure it
Again, click to next
Select the primary server
Select full mesh
Schedule bandwidth
create replication job
Created replication job
Directory Structure
using DFS useful for even security complete hide the Directory Structure
CREATE TABLE IF NOT EXITS QueryPanel_Employee (Emp_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, FIRST_NAME CHAR(25),LAST_NAME CHAR(25),SALARY INT(20),JOINING_DATE DATETIME,
SELECT substring(FIRST_NAME,1,3) FROM worker; SELECT SUBSTRING(LAST_NAME,1,2) FROM worker; SELECT SUBSTRING(LAST_NAME,1,4) FROM worker; SELECT SUBSTRING(LAST_NAME,2,5) FROM worker;
(INSTR) SELECT INSTR(FIRST_NAME,BINARY’A’) FROM worker WHERE FIRST_NAME = ‘amitabh’;
(SELECT QUERY FETCH ALL DATA)
SELECT * FROM north_busess_driver_details;
(WHERE CLAUSE) SELECT * FROM north_busess_driver_details WHERE Driver_id =’1′;
SELECT * FROM north_busess_driver_details WHERE D_NAME=’ABC’;
(IT WILL FETCH THE DETAILS WHAT WE HAVE MENTION IN QUERY)
SELECT Driver_id,D_NAME,PHONE_NUMBER FROM north_busess_driver_details WHERE Shift=’Morning’;
(AND OPERATOR IN SELECCT QUERY)
SELECT * FROM north_busess_driver_details WHERE D_NAME=’OL’ AND PHONE_NUMBER=’099′;
(OR OPERATOR IN SELECT QUERY)
SELECT * FROM north_busess_driver_details WHERE Driver_id=”011″ OR ADDRESS=”DEL”;
SELECT F_NAME,PHONE_NUMBER FROM north_busess_driver_details WHERE ADDRESS=”DEL” AND D_NAME=”OP”;
SELECT F_NAME,PHONE_NUMBER FROM north_busess_driver_details WHERE ADDRESS=”DEL” OR D_NAME=”OP”;
(DISTINCT)
SELECT DISTINCT D_NAME FROM north_busess_driver_details;
(DISTINCT COUNT)
SELECT COUNT(DISTINCT Driver_id) FROM north_busess_driver_details;
(NOT)
SELECT * FROM north_busess_driver_details WHERE NOT ADDRESS=’DEL’;
SELECT * FROM north_busess_driver_details WHERE NOT ADDRESS=’DEL’ AND NOT ADDRESS=’BIH’;
(ORDER BY ASC / DESC)
SELECT * FROM north_busess_driver_details ORDER BY Driver_id ASC;
SELECT * FROM north_busess_driver_details ORDER BY Driver_id DESC;
SELECT * FROM north_busess_driver_details ORDER BY D_NAME DESC;
(ASC/DESC WHERE CLAUSE)
SELECT * FROM north_busess_driver_details WHERE Driver_id=”11″ ORDER BY D_NAME ASC;
(UPDATE COLUMN) UPDATE north_busess_driver_details SET D_NAME=’BA’ WHERE Driver_id=’11’; (UPDATE overall Table) UPDATE north_busess_driver_details SET D_NAME=’BA’; UPDATE north_busess_driver_details SET D_NAME=’AA’ AND ADDRESS=’DEL’ WHERE Driver_id=’002′;
DELETE FROM north_busess_driver_details WHERE Driver_id=’501′;
DELETE FROM north_busess_driver_details;
(LIMIT)
SELECT * FROM north_busess_driver_details LIMIT 25;
(LIMIT PERTICULAR) SELECT Driver_id FROM north_busess_driver_details LIMIT 30;
SELECT * FROM north_busess_driver_details WHERE Driver_id=’11’ AND D_NAME=’D’ ORDER BY Shift LIMIT 1;
SELECT * FROM north_busess_driver_details WHERE Driver_id=’11’ OR D_NAME=’D’ ORDER BY Shift LIMIT 1;
(COUNT)
SELECT COUNT(Driver_id) FROM north_busess_driver_details;
SELECT COUNT(D_NAME) FROM north_busess_driver_details;
(AVG)
SELECT AVG(D_NAME) FROM north_busess_driver_details;
(SUM)
SELECT SUM(STATUS) FROM north_busess_driver_details;
(LIKE)
SELECT * FROM employee WHERE last_name LIKE ‘%a’
SELECT * FROM employee WHERE last_name LIKE ‘%S’
SELECT * FROM employee WHERE last_name LIKE ‘S%’
SELECT * FROM employee WHERE last_name LIKE ‘W%S’
SELECT * FROM employee WHERE first_name LIKE ‘%’
SELECT * FROM employee WHERE job_title LIKE ‘S%S’;
