Home » 2014 (Page 8)
Yearly Archives: 2014
Steps to install Service Pack for SQL Server 2005 – Multiple Instances
Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :- Step 1 : First page of Service pack setup. Informatory details only. Step 2 : Confirm EULA (End User License Agreement) to move ahead. Step 3 : Select instance & features you want to patch or upgrade. Note : … Continue reading
How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation. SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’ FROM SYS.SERVER_PRINCIPALS WHERE SID = 0X010100000000000512000000 SID 0X010100000000000512000000 is belongs to user "NT AUTHORITYSYSTEM". This user create at the time of installation only. If you liked this post, do like on … Continue reading
Mainstream Support End || SQL Server 2008 and SQL Server 2008 R2
Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 was ended on July 8th 2014. This will result no enchantment or no future release of SPs. Somehow, Critical bug fixes may be release as QFE etc. This sequence stop with SQL Server 2008 Service Pack 3 CU16 and SQL Server 2008 R2 Service … Continue reading
How to restore MSDB & MODEL database – SQL Server System Databases?
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. Issues in MSDB restore that may result loss of all scheduling information, as well as the backup and restore history. You cannot restore a database that … Continue reading
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