Database Reference
In-Depth Information
Update statistics include:
F
Rebuild indexes on user database tables
F
Re-organizing indexes if it is a very large database
F
Rebuild cubes
F
Reconfigure log shipping
F
Database mirroring
F
Test a failover cluster
F
Verify that SQL Server Agent jobs run correctly
Backward Compatibility—Deprecate & Discontinued features
Backward compatibility with earlier versions of SQL Server was a high priority from SQL Server
2008 version onwards. So in most cases, applications will behave as in the past. There are
several features from SQL Server 2008 version onwards that are marked for removal in the
next version of SQL Server.
After you upgrade, you should remove the usage of these features from existing applications
and avoid them in new development work. Several features from earlier versions of the SQL
Server Database Engine are not supported in SQL Server 2008 and SQL Server 2008 R2, so
you must use replacement features for these.
With an in-place upgrade, the upgrade process handles all aspects of the upgrade,
automatically by upgrading the metadata for each database found in SSAS 2005. However,
for SQL Server 2000, the upgrade process will not automatically reprocess the upgraded
databases. Each database must be fully processed after the upgrade to ensure users can
access the data that is contained in each database.
If there is a frequent upgrade failure, then the easiest resolution is to reinstall SSAS 2000.
Restore the installation to the state before the upgrade process was started. This ensures
that all the data and configuration information that is needed to restore the existing
installation is available
The manual transfer of database objects needs to be performed with utmost care due to the
nature of all database objects (inclusive within database and exclusive of database). The
outer objects of SQL Server are also important for databases, such as the objects that you
must transfer, which include the following:
F
Data files
F
Database objects
F
SSAS cubes
F
Configuration settings
F
Security settings
F
SQL Server Agent jobs
F
SSIS packages
Search WWH ::
Custom Search