Posted by Erland Sommarskog on 04/16/07 07:19

(bosko19@gmail.com) writes:
> The database server has a dash in it (i.e. CompanyName-SQL1 and SQL2
> respecitvely). All databases are just alpha characters except for one
> that begins with a number sequence (i.e. 1000DatabaseName).

What service-pack level are you at? (For all three machines.)

If you are on SP2, you should definitely submit a bug on
http://connect.microsoft.com/SqlServer/. And if it's not an acceptable
workaround to rename the servers, I think you should open a case with
Microsoft, and demand that you get a hotfix.

If you are not on SP2, I recommend you to download it to see if it addresses
the problem. Note there is a rollup to SP2 which addresses two serious
bugs with maintenance plans. Make sure you get the rollup, if you use
maintenance plans.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Access to different databases in different domains
• Prev in forum: Re: Need help writing a query
• Thread view: Re: Database Mirroring Monitor Job Error

[Reply to this message]