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.
Deepak Bhardwaj
Author's posts
Jun 03
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 …
Jun 02
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 …
Jun 02
SQL Database Log shipping
Jun 02
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 …
Jun 01
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 …
Jun 01
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 …
Jun 01
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 …
