Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » configuration   (RSS)
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
Tuesday, October 21, 2008 4:17 PM

Non-yielding Scheduler, IO Warnings and Cluster Failover

Here's another example of SQL Server producing a dump file which can help you diagnose critical problems. The scenario here is a a clustered SQL Server 2005 instance fails over and we need to investigate why. A good place to start in such problems (as
Posted by grahamk | 0 Comments
Thursday, September 11, 2008 6:49 PM

Non-yielding IOCP Listener - Stack Dump analysis

Here's something I was looking at yesterday which is worth a quick look. It's quite a common scenario and one that's relatively easy to address. Your SQL Server 2005 instance suddenly throws the following to the error log (apparently without warning):
Posted by grahamk | 0 Comments
 
Page view tracker