I installed SQL Server 2008 (R2) on my machine alongside SQL
Server 2005, which was already on there as the default instance; I named my
2008 instance “SQL2008”.
If you’re like me, you have lived the past few years without
the need to think about default instances.
So remember that stuff like “(local)” will connect to your 2005
instance, and “(local)\SQL2008” will connect to your 2008 instance.
SSMS 2008 will gladly connect to your (default) 2005
instance, and then you will be left scratching your head trying to figure out why
you can’t create databases with a compatibility level of 100, or continue to
get frustrating errors trying to restore 2008 backups.
That’s my errant move of the day, I hope this finds you
before you do anything drastic.
No comments:
Post a Comment