Toad World

Blogs

Rohit Garg
Follow /27 Apr 2015 at 5:18am / SQL Server Blog

Cumulative Update – 15 for SQL Server 2012 Service Pack 1 Is Now Available !

The 15th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 15 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
550 0 /
Rohit Garg
Follow /27 Apr 2015 at 5:15am / SQL Server Blog

Cumulative Update – 7 for SQL Server 2014 RTM Is Now Available !

The 7th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 7 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe...
590 0 /
Rohit Garg
Follow /24 Apr 2015 at 5:49am / SQL Server Blog

Window Server 2008 Failover Clustering Logs

In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in readable plain text format & located in %SystemRoot%\Cluster folder on each node in the cluster and the name of the file is CLUSTER...
895 0 /
Rohit Garg
Follow /13 Apr 2015 at 5:07am / SQL Server Blog

How to restore Master database – SQL Server System Database?

Steps to restore SQL Server Master Database :- 1) Stop SQL Server Services 2) Add [-m] startup parameter in SQL Services from configuration manager Parameter [-m] Starts SQL Server instance in single-user mode. SQL Server in single-user mode can...
930 0 /
Rohit Garg
Follow /8 Apr 2015 at 4:14am / SQL Server Blog

How to move Resource DB in SQL Server ?

The Resource database is a read-only database that contains all the system objects. This DB included with SQL Server 2005 to increase security of system metadata. SQL Server system objects, such as sys.objects , are physically persisted in the Resource...
757 0 /
Rohit Garg
Follow /2 Feb 2015 at 11:06am / SQL Server Blog

How to Rebuild MSDB database?

I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then you have to rebuild it. You can do it by instmsdb.sql script comes with installation. It...
978 0 /
Rohit Garg
Follow /22 Jan 2015 at 12:24pm / SQL Server Blog

How to install standalone SQL Server 2012 instance ?

Steps to install standalone SQL Server 2012 instance 1) Start the setup > Go to Installation from Left > Click on 1st option of New SQL Server standalone edition from right 2) Click Ok to cont., In case of any failure, you need to fix that...
949 0 /
Rohit Garg
Follow /3 Jan 2015 at 5:09am / SQL Server Blog

A Very Happy New 2015

Wishing you a very happy new year to you. May this year bring success & happiness in your life. Reference : Rohit Garg ( http://mssqlfun.com/ ) You can find and follow MSSQLFUN :- http://www.facebook.com/mssqlfun http://mssqlfun.com/feed...
518 0 /
Rohit Garg
Follow /31 Dec 2014 at 4:13am / SQL Server Blog

2014 – One more Year with you

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 73,000 times in 2014. If it were an exhibit at the Louvre...
583 0 /
Rohit Garg
Follow /26 Dec 2014 at 3:44am / SQL Server Blog

Cumulative Update – 5 for SQL Server 2014 RTM Is Now Available !

The 5th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe...
445 0 /