Small Business Susan

Top SQL issues from the Managed newsgroup

Top issues from the managed newsgroup


Partner Online Technical Support Communities Newsgroups:
https://partner.microsoft.com/US/40014662


In this Issue:

 

TOP SUPPORT ISSUES

 

NEW & UPDATED KB ARTICLES

 

NEW & TOP DOWNLOADS

 

NEW WEBCASTS

 

 

RECENT SUPPORT ISSUES

===================

Issue

———-

 

You want to move databases to a new SQL server running Windows Server 2003

x64 and SQL Server 2005 x64.



Analysis

——–

Database itself is not related to 32/64 bit. You just back up the database on a 64 bit instance and restore it to 32 bit instance without problem. However, please note that the version of the destination instance should be the same or higher than the source instance.

 

Resolution

————–

Back up the databases on a 64 bit instance and restore them to 32 bit instance without problem. Or backup the databases on 32 bit instance and restore them on 64 bit instance.

 

 

 

NEW & UPDATED KB ARTICLES

=========================

 

Access

——

 

960307  Description of the Access 2007 hotfix package (Access.msp): December 16, 2008

http://support.microsoft.com/default.aspx?scid=kb;EN-US;960307

 

958846  Error message when you try to create a new database in Access 2007: “Template could not be instantiated”

http://support.microsoft.com/default.aspx?scid=kb;EN-US;958846

 

SQL

—-

 

957826  Where you can find more information about the SQL Server 2008 builds that were released after SQL Server 2008 and the SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2

http://support.microsoft.com/default.aspx?scid=kb;EN-US;957826

 

957807  FIX: A new node is not added to a SQL Server 2008 Analysis Services cluster or a SQL Server 2008 Reporting Services cluster if the SQL Server 2008 Database Engine is not installed

http://support.microsoft.com/default.aspx?scid=kb;EN-US;957807

 

 

NEW & TOP DOWNLOADS

====================

SQL Server 2005 Books Online (November 2008)

http://www.microsoft.com/downloads/info.aspx?na=22&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3dbe6a2c5d-00df-4220-b133-29c1e0b6585f%26DisplayLang%3den

 

Microsoft SQL Server 2008 Express

http://www.microsoft.com/downloads/info.aspx?na=22&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d58ce885d-508b-45c8-9fd3-118edd8e6fff%26DisplayLang%3den

 

Microsoft SQL Server 2008 Express with Tools

http://www.microsoft.com/downloads/info.aspx?na=22&p=3&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d7522a683-4cb2-454e-b908-e805e9bd4e28%26DisplayLang%3den

 

Microsoft SQL Server 2008 Books Online (January 2009)

http://www.microsoft.com/downloads/info.aspx?na=22&p=5&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d765433f7-0983-4d7a-b628-0a98145bcb97%26DisplayLang%3den

 

NEW WEBCASTS

============                

 

Getting your feet wet with SQL Server 2008: SQL Server Monitoring – February 19, 2009

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032396920&EventCategory=2&culture=en-US&CountryCode=US