Deepak Bhardwaj

IT Consultant of almost 10 years of experience with various business vertical in IT Infrastructure Service, methods, processes, strategic technology infrastructure planning, and developing cost effective solutions to meet customer business requirements.

Author's posts

Moving TempDB

Steps to move TempDB Database. 1. Open SQL Server Management Studio. 2. Connect to the desired server. 3. Click the New Query button. 4. Copy and paste the following into the query pane: USE master; GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = ‘{new location}tempdb.mdf’); GO ALTER DATABASE tempdb MODIFY FILE (NAME …

Continue reading

Microsoft ISA Server 2006, Firewall Client Configuration

Microsoft ISA Server 2006, Firewall Client Configuration Microsoft ISA Server 2006 Fire wall clinet

Script to copy Backup file from DB server to Backup server

Script to copy Backup file and if require  you can send mail once backup file copied. To configure mail service need to permit the system IP to communicate rellay server and than SMTP service. On error resume next ‘ VBScript source code ”Deepak Bhardwaj ”Comments: ”        This code is copying the backups from …

Continue reading

Problem faced when you install SQL Server 2005 on a computer that is running Windows Server 2008

Workarounds for Problem faced when you install SQL Server 2005 on a computer that is running Windows Server 2008 SQL Server 2005 on Windows Server 2008

SQL Database Log shipping

Step by Step configuration of SQL Database Log shipping. This document applies on SQL Server 2008. SQL Database Log shipping

Step by Step SQL Server 2008 Database Active/Passive Cluster

Clustering can be described as a technology that automatically allows one physical server to take over the tasks and responsibilities of another physical server that has failed. An Active/Passive SQL Server cluster means where only one instance of SQL Server is running on one of the physical servers in the cluster, and the other physical …

Continue reading

Step By Step Configuration of Oracle Service on Windows Cluster 2008R2

This document outlines the step by step process to install Oracle11G Standard Edition on Windows Server 2008R2 failover Cluster. Oracle Service on Windows Cluster

How to Change Cluster IP Address in Windows 2008R2!

Cluster.exe will show you cluster groups and resources that are not shown in the Failover Cluster Management Console. C:>Cluster.exe group Listing status for all available resource groups: Group Node Status ——————– ————— —— Available Storage WINCLUDB Offline Cluster Group WINCLUDB Online MBX W2K8CCR1 Online C:>Cluster res Listing status for all available resources: Resource Group Node …

Continue reading

SQL Database Mirroring

Database Mirroring Database mirroring is the creation and maintenance of redundant copies of a database. The purpose is to ensure continuous data availability and avoid downtime that might otherwise result from data corruption or loss, or from a situation when the operation of a network is partially compromised. Apply on SQL Server 2005 and 2008 …

Continue reading

About Me

I’m Deepak Bhardwaj over 15 years of experience in IT industry. Having solid exposer in Domestic and Globel complex organizations database operations Management. Key responsibility area (Operation stability, standardization, Management, Monitoring, Complex Infra Implementation and Monitoring tools (Implementation, Testing and Reporting). I am persistent in my avocation of the Exceptional customer experience, the Exceptional employee …

Continue reading

WP2Social Auto Publish Powered By : XYZScripts.com