Welcome to MSDN Blogs Sign in | Join | Help

November 2008 - Posts

Thursday, November 27, 2008 10:22 AM

Problems executing maintenance plans in SQL Server 2008

In the RTM build of SQL Server 2008 , if you install the tools in any edition, you are able to create maintenance plans. However depending upon your version and your extact installation components, when you execute the maintenance plan you created, you
Posted by grahamk | 1 Comments
Friday, November 21, 2008 4:04 PM

How to configure SQL Server database mirroring between 2 instances on a standalone server

There are lots of troubleshooting articles about how to diagnose connectivity problems when setting up database mirroring, especially errors such as these: Msg 1418, Level 16, State 1, Line 2 The server network address "tcp://mirrortest.com:5023" can
Posted by grahamk | 1 Comments
Thursday, November 13, 2008 4:54 PM

Interesting things to watch out for when using the autoclose database option

Here's something which I've been looking at this week, surrounding the autoclose database option. When you restore any database to a SQL Server 2005 SP2 or later instance, you'll more than likely get errors of this nature written to the log. 2008-11-12
Posted by grahamk | 2 Comments
Thursday, November 13, 2008 9:21 AM

Want to read some tips and tricks from the SQL Developer support team?

Well if you do you should check out the blog of my colleague and Microsoft pool team partner Spike, who works in the SQL Support team here with me in Stockholm, but specialises in the area that we refer to as developer support. This is a very broad area
Posted by grahamk | 0 Comments
Wednesday, November 12, 2008 10:35 AM

Database Mirroring Monitor can cause large tempdb growth in SQL Server 2005 - changed behavior in SQL Server 2008

On extremely rare occasions in SQL Server 2005, when the following conditions are true: 1. You have a database configured for database mirroring 2. You have replication configured on the same database 3. You are running the database mirroring monitor
Posted by grahamk | 0 Comments
 
Page view tracker