SQL Server Administration
 The
following articles are designed to help you administer SQL Server:
Understanding SQL Server backup types
Database backups are at the core of any SQL Server disaster recovery planning
for any production system. Microsoft® SQL Server™ provides several kinds of
backups that may be combined to formulate a customized disaster recovery plan
depending on the nature of the data and the recovery requirements.
Read more...
Microsoft released SQL Server 2005 SP2 CTP
Microsoft released SQL Server SP2 Community Technology Preview (CTP)
this month to address a number of known issues and provide some
enhancements to the database engine. Remember that this service pack is
still a CTP and is not intended for use in production.
Read more...
Longhorn, Vista to drop SQL Server 2000 and MSDE support
In
a surprise move, Microsoft announced that the soon-to-be released Microsoft
Windows Vista operating system and Microsoft Windows Server "Longhorn" will
not support earlier versions of SQL Server, including SQL Server 2000 (all
editions including MSDE), SQL Server 7.0, and SQL Server 6.5.
Read more...
More Articles
How many rows does
your largest SQL Server table contain?
How big is your
database log file?
Compare SQL Server 2005
Editions
Verify foreign key integrity
Reclaim space for dropped columns
Monitor SQL Server disk space
usage
Limit SQL Server
memory usage
List available
SQL Server instances on the network
Determine SQL Server table size
View SQL Server Agent job history
Automate archival of daily SQL Server
backups
Resolve error "SQL Server
does not exist or access denied"
Resolve error "Specified
SQL Server not found"
What is SQL Server Utility?
SQL query analyzer tool
Resolve error "ot associated with a trusted sql server connection"
SQL Server Client
Network Utility
MDAC explained (ADO version 2.5, 2.6, 2.7, and 2.8)
|
