Search
Subscribe
Categories
- Backup and Restore
- Capacity Planning
- Compression
- Configure
- Contact me
- CPU
- Data Architecture
- Data Import and Export
- Database Mirroring
- DBA
- DBA Scripts
- DBCC
- Deadlocks
- Default Trace
- Development
- Disaster Recovery
- Disk Storage
- DMV
- Documentation
- Event Log
- Execution Plan
- Function
- High Availability
- Indexes
- Install & Setup
- Interviews
- IO Subsystem
- Isolation levels
- Jobs
- Latches
- Links
- Locking
- Memory
- Monitor Performance
- MS DTC
- MSDB
- Network
- Object Management
- Pagination
- Partitioning
- Performance
- Powershell
- Security Management
- SQL Agent
- SQL Azure
- SQL Blocking
- SQL Cachestore
- SQL DAC
- SQL Default Trace
- SQL DTS
- SQL Error Logs
- SQL Execution Plan
- SQL Optimizer
- SQL problems
- SQL Query Tuning
- SQL Server Error Tips
- SQL Server Management Studio
- SQL Server Profiler
- SQL Server Tuning
- SQL Trigger
- SQL View
- SQLServer-DBA News
- SSIS
- Statistics
- Stored Procedure
- T-SQL
- TempDB
- Tools
- TPC-H
- Transaction Logs
- View
- Virtualization
- Wait Stats
SQLServer-DBA.com Links
Recent Posts
- Shredding XML with Powershell and SQL Server
- Task Manager not showing correct SQL Server memory usage
- The value of training and How to convince your boss
- SQL Error 1204 - cannot obtain a LOCK resource at this time
- Multi-statement table valued function and inefficient Excecution Plan
- SQL Server Export to Excel with Powershell
- Who dropped the table in SQL Server
- List sql database roles
- SQL Execution Plan - Comparing Estimated Rows and Actual Rows
- DCOM got error "Logon failure: unknown user name or bad password” Event 1004
05 September,2010 by Jack Vamvas
Upgrading from SQL Server 2000 to SQL Server 2005 (or SQL Server 2008) requires some organisation. It is important to create and maintain a task list.
I use the general list of tasks as a basis or template. I customise the list for every SQL Server instance. By the end of the consultation the list can grow to over 100 tasks , depending on the database server size , the amount of application layer built in to the database and the server environment.
The example below is a real-world example of a task list. It was a SQL Server 2005 upgrade .
I manage the task list through Microsoft Excel. Every task is associate with categories:
When (PreConfig,Post Config)
Source (Monitoring,Backup,DTS,Databases,Server)
Owner (Main reference for task)
Start Time
End Time
Status
Comments
I also have detailed upgrade plans for every component – such as Backup devices plan, SysMessages , Replication, DTS, Pre Upgrade, Post Upgrade etc.
|
Confirm RSA support |
|
MYDB delete tables |
|
Allow dummy drives(H: I: J: ) |
|
Confirm existing sql server 2000 installation scripts |
|
Confirm sql server 2000 binaries are in location |
|
Prepare SQL Server Installation scripts |
|
TSM Client Drivers for SQL Server 2005 |
|
Install\Confirm Monitoring drivers for 2005 |
|
usage of cname is done - server1.mydomain.net |
|
Default language settings for English - check script |
|
Confirm DTS tested on 2005 |
|
Confirm Jobs tested on 2005 |
|
Analyze system databases for user-defined objects |
|
Develop “Fix upgrade issues in SQL Tasks” script |
|
usage of cname - server1.mydomain.net |
|
Script Jobs |
|
Script Alerts |
|
Script Operators |
|
Script Backup Devices |
|
Script User-defined messages |
|
Script Users, Roles and Logins |
|
Backup all databases to TSM |
|
Change backup schedule change for the weekend |
|
Backup all databases to to Local Disk |
|
Confirm from owner it is OK to proceed with upgrade |
|
Request mirrorrs are broken |
|
Uninstall BMFMySQL on Server1 |
|
Detach databases |
|
Uninstall server1\myinstance |
|
Install SQL Server 2005 - Standard Edition |
|
Install SQL Server 2005 - Service Pack 2 |
|
DTS Designer Install |
|
Restore databases via attach |
|
Execute Script Linked Server Configuration |
|
Execute Script Jobs |
|
Execute Script Alerts |
|
Excute Script Operators |
|
Execute Script Backup Devices |
|
Execute Script User-defined messages |
|
Execute Script Users, Roles and Logins |
|
Execute scripts - \config\* |
|
UPDATE STATISTICS with FULL SCAN |
|
updateusage |
|
recompile all objects |
|
refreshallViews |
|
SQL Server Index Maintenance Strategy |
|
Implement Database Backup Maintenance Plans |
|
Check Monitoring is connecting user 'itmsql' |
|
hand over to owners |
|
Signed of by Application Owner |
|
Run ETL |
|
Notify storage to reset mirrors |
As I progress through the upgrade , the task list is altered to reflect new issues or tasks. For example, there may be a requirement to complete a SQL Server security audit or a DTS to SSIS .
Read More
SQL Server 2005 memory configuration ... - SQL Server DBA
SQL Server database files configuration checklist - SQL Server
Author: Jack Vamvas (http://www.sqlserver-dba.com)
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |