I recently join an organisation and I need to check if the sql servers are licensed or not( I have no experience in SQL licensing at all, all I know is they are supposed to be Core base licenses ) . any idea why I get disabled when I run “ SELECT SERVERPROPERTY('License Type')
I believe from SQL 2005 and on, the license information isn't tracked inside the application (http://blogs.msdn.com/b/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx) any longer.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed