Below script will query registry settings to return folder informations (SQL Root, Data, Log and Backup).
I use this script to determine the default locations, put it in variables an use it for creating databases or backups.
DECLARE @SQLDataRoot nvarchar(512)
DECLARE @DefaultData nvarchar(512)
DECLARE @DefaultLog nvarchar(512)
DECLARE @BackupDirectory nvarchar(512)
-- check defaults
-- installation directory
-- sql server root
-- 'data' directory
-- 'log' directory
-- 'backup' directory
-- default locations set?
IF LEFT(REVERSE(@SQLDataRoot), 1) <> N'\'
SET @SQLDataRoot = @SQLDataRoot + N'\'
-- regkey = 0 then default root
SET @DefaultData = ISNULL(@DefaultData, @SQLDataRoot + 'DATA')
SET @DefaultLog = ISNULL(@DefaultLog, @SQLDataRoot + 'DATA')
PRINT '''Data'' - Directory : ' + @DefaultData
PRINT '''Log'' - Directory : ' + @DefaultLog
PRINT '''Backup'' - Directory : ' + @BackupDirectory
In a earlier previous post - Which service pack do I have installed? - based on How to identify your SQL Server version and edition and using
for a deep dive to SQL Server version information, the guys of http://sqlserverbuilds. blogspot. com
gives you an unofficial build chart lists all of the known KB articles, hotfixes and other builds of MS SQL Server 2008, 2005, 2000 and 7.0 that have been released.
They will do it! Here is the statement of Matthias Berndt, Group Program Manager Microsoft SQL Server:
SQL Server Servicing plans
Hello Community, we appreciate your recent comments regarding the servicing needs of your current SQL Server configurations. We want to assure you that we are fully committed to our existing customer base, hence hereby clarification around our near term servicing deliverables:
* SQL Server 2008 SP2. Microsoft targets release in Q3/CY2010.
* SQL Server 2005 SP4. You overwhelmingly requested another servicing release for SQL Server 2005. Given your feedback Microsoft targets now such release in Q4/CY2010. Based on current support volume as well as the fact that SQL Server 2005 will enter into extended support on 4/13/2011 we anticipate this to be the last Service Pack release for this SQL Server version. Extended support for SQL Server 2005 will be available through 4/12/2016. Please see http://support.microsoft.com/lifecycle/ for specifics. As always, the SQL Server team will carefully monitor customer feedback as well as support volume to re-assess our decisions based on your needs.
SQL PASS Franken - Di 9.2.2010 18:30 Uhr - Sichern, Wiederherstellen, Integrity Check und Index Optimization
Mention, the CSS SQL Server Engineers blog listed a note that some end of support dates were coming up.
SQL Server 2008 RTM support ends on April 13, 2010. You should make plans to upgrade to SQL Server 2008 SP1 soon.
So I think, it is definitely time to start thinking about upgrading your instances to SQL Server 2008 SP1!
Last week the CSS SQL Server Engineers blog listed a note that some end of support dates were coming up. The end of support dates and products were:
- SQL Server 2005 Service Pack 2 support ends next week January 12, 2010. You should upgrade to SQL 2005 SP3 or SQL 2008 SP1 immediately.
- SQL Server 2008 RTM support ends on April 13, 2010. You should make plans to upgrade to SQL Server 2008 SP1 soon.
There for I guess we have to vote for:
I am wondering when Service Pack 4 for SQL Server 2005 is slated to be released. Many companies will not install CUs, and depend on SPs to provide additional stability and patch their systems. Release Services has stated that there will be one SP a year, containing all CUs in it.
SQL Server 2005 SP3 was released on Dec 15, 2008. It is now over one year old.