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
Read the complete post at http://msmvps.com/blogs/bradley/archive/2009/02/13/top-sql-issues-from-the-managed-newsgroup.aspx