I get this question often from various levels of technical people. They typically have experience with Exchange servers, and they know that after a successful backup Exchange will truncate or cleanup it’s database log files. They mistakenly think that SQL will do the same. Let’s explore why each of these takes place and what is going on here. Historically … [Read more...]
How can I tell what version of SQL I have?
I’ve had this question a few times now where I am trying to determine what version of SQL server I have installed on a computer. This website here shows you all the versions of SQL based on the build number and the SQLServer.exe. You can also use the SQL Management Studio to show the version as per below. … [Read more...]
What service packs exist for SQL Server 2000? – Wayne Small
Currently Service Pack 3 for SQL 2000 is the most recent. Release Dates Service Pack 1 - June 12, 2001 Service Pack 2 - November 30, 2001 Service Pack 3 - January 16, 2003 … [Read more...]
Will SBS 4.5 automatically upgrade my SQL 6.5 database to SQL 7?
No. A utility is provided to migrate the data from SQL 6.5 to SQL 7.0. … [Read more...]