Home » SQL Server (Page 24)
Category Archives: SQL Server
How to change TempDB system Database files location?
Steps to change TempDB system Database files location :- 1) Check current file location of TempDB Exec SP_helpDB TempDB You can use below query as well for file location details. SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE database_id = DB_ID(‘TempDB’); 2) Execute Alter Database command with Modify Filename option on Tempdb System Database … Continue reading
Cumulative Update – 2 for SQL Server 2014 RTM Is Now Available !
The 2nd cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe issues with their environment, they can plan to test CU2 in test environment … Continue reading
Cumulative Update – 13 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 13th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP2. Those who are facing severe issues with their environment, they can plan to test … Continue reading
Rename or Change SQL Server Standalone Default Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Instance. Step 1 : Check Current Instance & host name Current Host Name : admin-0783e4076 Current SQL Instance Name : admin-0783e4076 Select @@ServerName ServerName, Host_name() HostName Step 2 : Rename Host name & reboot the server Step 3 : Try … Continue reading
SQL Server 2014 – How to add features to existing instance ?
SQL Server 2014 – How to add features to existing instance ? :- 1) Start installation center 2) Run Global Rule, You need to fix if any failure occur 3) Microsoft update option (Enable windows updates to search & install SQL updates as well) 4) Include product update with installation, (the latest available SQL Server … Continue reading