Pages

▼
Showing posts with label IT» SQL. Show all posts
Showing posts with label IT» SQL. Show all posts
Monday, 19 November 2018

Moving SQL Server tempdb Files to a Different Location in SQL 2016

›
SQL Server performance improves if data, logs, tempDB data and temDB logs resides in separate drives. If data and logs are in same dri...
Wednesday, 31 August 2016

Troubleshooting The remote procedure call failed. [0x800706be] WMI Error in SQL Server 2012

›
SQL: You may end up getting "The remote procedure call failed. [0x800706be] WMI Error" when you click SQL Server Services ...
Tuesday, 29 April 2014

Failover cluster node setup Errors

›
setup errors in SQL cluster environment.. TITLE: SQL Server Setup failure. ----------------------------...
Tuesday, 24 September 2013

CREATE DATABASE failed with clustered Microsoft SQL Server 2008 instance : resolved

›
Trying to create a database on a clustered SQL 2008 instance? Getting the following error message? Cannot use file 'D:\MSS...
Wednesday, 28 November 2012

Scheduled Maintenance Plan for SQL Express DBs

›
Automate Database backup with SQL Express using scripts and batch schedule Let us automate database backup in SQL Express with...

Required Housekeeping on SQL Server after renaming the hostname

›
SQL Server 2008 – Server Name Change (compiled and written by Rinith) It might cause serious impact for your business ...
1 comment:
Wednesday, 8 August 2012

Important Checklist to Install SQL Server 2008 R2 Failover Cluster on Windows 2008 R2 Failover Cluster

›
    Preparing server from scrap.. lemme prepare the checklist first.. in a nutshell... Configure RAID – for OS redund...

The credentials you provided during SQL Server 2008 installation are invalid

›
When providing service accounts and passwords you might encounter one of the following error messages, which prevents you from conti...
1 comment:

Pre-requisites for SQL 2008 R2 Failover Cluster setup: MSDTC Setup

›
Microsoft Distribution Transaction Cordinator  setup process: now proceed with SQL system confi...
1 comment:

SQL 2008 pre-requisites: Determine and Set the Primary NIC on a Windows 2008 Server

›
NIC Binding is the order at which windows loads the NIC's at boot up and takes the first one as a primary NIC. How to Determine a...

Validation errors while installing SQL 2008 R2 on Node 2 Cluster

›
The errors what I encountered while validating on SQL node 2. Before I proceed with Node 2 installation, windows 2008 failover clust...

Adding SQL Node 2 Cluster services (MSCS) verification error

›
Error Code 0x80071398 Error..! never mind. I evicted the node from the cluster and re-added it. Validate the cluster. It...
Tuesday, 7 August 2012

Problem installing SQL Server 2008 R2 Failover Cluster on Node 2

›
Exception from HRESULT: 0x80070006 HRESULT: 0x80070006 (E_HANDLE)) ---> System.Runtime.InteropServices.COMException (0x80070...
Sunday, 5 August 2012

SQL instance removal failed<<Quick Instance Removal

›
remove the instance by running the the syntax from command prompt where the SQL setup CD is mounted: G:\> setup /Action...
Sunday, 20 May 2012

How to change SQL Server Name or Instance Name

›
applies to all SQL ver including Denali. i. Open SQL Server Management Studio and click New Query. ii. Type Select @@ServerName...
Saturday, 19 May 2012

›
SQL 2008 R2 'Cluster Name' registration failure .. event ID 1196 and Event ID 1119 this is important for setting up SQL 2008...
Wednesday, 16 May 2012

check backup and restore progress in SQL Server

›
The below script may be helpful in checking the status of huge database activity. The below script will work for any backup or restore t...

SQL Backup and Restore.. any version

›
GUI simplified and short..... Backup Database: in this example citrix CAG database (qdc-ctx-aac) is explained. Rt. click from t...