June 2010 - Posts

15 June 2010
Upgrade to 2008 R2

I don't like it, Carruthers. It's just too quiet. Well, I've done the pre-production server, the main live server and the Reporting/BI server with remarkably little trouble. Pre-production and live were rebuilds. I failed live over to our log shipping standby for the duration, which has a... Read More...

no comments

Filed under: SQL Server 2005, SQL Server 2008 R2, Upgrading

12 June 2010
Fun with Database Mail

I just had some fun with a new server I set up. I configured Database Mail but it wouldn't send mail. In the Database Log was an error message I've never had before: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-02-15T16:58... Read More...

no comments

Filed under: Database Mail

11 June 2010
Upgrading log shipping from 2005 to 2008 or 2008R2

If you're using log shipping you need to be aware of some small print. The general idea is to upgrade the secondary server first and then the primary server because you can continue to log ship from 2005 to 2008R2. But this won't work if you're keeping your secondary databases in STANDBY... Read More...

no comments

Filed under: SQL Server 2005, Log Shipping, SQL Server 2008, SQL Server 2008 R2