Hourly Rate: Not Sure
| Duration: Not Sure
| Posted: Mar 08, 2014 | Ends: 47d, 16h |
There is a project to migrate 12 SQL 2000 to new blade servers (windows 2012 with SQL 2012 Cluster) . The current system is SQL 2000 SP4 in a legacy windows 2000 servers. There are 12 instances and about 60 G data. The new SQL servers 2012 clustered with a ISCSI storage in window 2012 server. You need use RDP tools to remote log in the servers. And the operator will assist you on site. Please submit your solutions of SQL migration, SQL cluster and SQL benchmark test and Suggestion. 1. Describe your solution to migrate SQL 2000 to SQL 2012 include what T-SQL scripts will be(Please give example) and what SQL tools you will use to implement the project. 2. Describe how will you benchmark SQL server, what kind of tool you can use to test SQL IO input/out activities and so on. 3. Describe which items need manually configure during SQL upgrade, For example, legacy email notification and linked server configuration will be lost during migration and you have to add them back manually. 4. D...
Category: Database Administration