http://www.sqlmag.com/authors/author/author/5306532/rsscomment/5306532en-USFri, 25 May 2012 11:04:01 GMTFri, 25 May 2012 11:04:01 GMThttp://www.sqlmag.com/article/sql-server/sql-server-database-engine-basics#commentsAnchorThu, 24 Feb 2011 01:48:55 GMT
"If the log truncation process fails, the transaction log will grow until it fills up the disk it resides on." Of course only if Autogrowth is enabled for this transaction log file, otherwise we get "Transaction Log file is full" error.]]>UnalThu, 24 Feb 2011 01:48:55 GMThttp://www.sqlmag.com/article/sql-server/sql-server-database-engine-basics#commentsAnchorhttp://www.sqlmag.com/article/sql-server/sql-server-database-engine-basics#commentsAnchorThu, 05 Aug 2010 14:30:54 GMT
Thank you Louis for taking time to cover the essential basics]]>podiThu, 05 Aug 2010 14:30:54 GMThttp://www.sqlmag.com/article/sql-server/sql-server-database-engine-basics#commentsAnchorhttp://www.sqlmag.com/article/sql-server/sql-server-database-engine-basics#commentsAnchorWed, 04 Aug 2010 06:20:07 GMT
Louis, thank you for taking time to put this together and help explain this very misunderstood topic.]]>CAYWOODWed, 04 Aug 2010 06:20:07 GMThttp://www.sqlmag.com/article/sql-server/sql-server-database-engine-basics#commentsAnchorhttp://www.sqlmag.com/article/tips/seven-tips-for-sql-server-production-dbas#commentsAnchorThu, 16 Jul 2009 10:56:13 GMT
In the third tip, the sentence regarding the Windows built-in Administrators group had contained a typo. The sentence said SQL Server 2005 when it should have said SQL Server 2008. The typo has now been corrected. Thanks for catching it Eugene! Karen Bemowski, senior editor SQL Server Magazine, Windows IT Pro]]>KarenThu, 16 Jul 2009 10:56:13 GMThttp://www.sqlmag.com/article/tips/seven-tips-for-sql-server-production-dbas#commentsAnchorhttp://www.sqlmag.com/article/tips/seven-tips-for-sql-server-production-dbas#commentsAnchorWed, 15 Jul 2009 09:18:51 GMT
Hi Just a question as to what you would do if your policy is to remove the builtin admin account after a SQL install is done then this will not work. Also I have always thought that buildin admin was sysadmin by default. Regards Brendan brendanc@nedbank.co.za]]>BrendanWed, 15 Jul 2009 09:18:51 GMThttp://www.sqlmag.com/article/tips/seven-tips-for-sql-server-production-dbas#commentsAnchorhttp://www.sqlmag.com/article/tips/seven-tips-for-sql-server-production-dbas#commentsAnchorSat, 04 Jul 2009 10:27:48 GMT
Hi, You wrote in the part "3. Use sp_addsrvrolemember to give yourself the sysadmin role. In SQL Server 2005, the Windows built-in Administrators group isn’t given the sysadmin role by default." did you mean sql server 2008? SQL Server 2008 doesn’t add BUILTIN\Administrators by default If you meant 2005 - it is incorrect: it is still sa role member by default in sql server 2005 More: How to impede Windows NT administrators from administering a clustered instance of SQL Server http://support.microsoft.com/default.aspx/kb/263712 How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult http://support.microsoft.com/kb/932881/ Thanks Eugene Zhitomirsky]]>EugeneSat, 04 Jul 2009 10:27:48 GMThttp://www.sqlmag.com/article/tips/seven-tips-for-sql-server-production-dbas#commentsAnchor