Lounge Network New Zealand
Lounge Network News and Network Status


RSS Subscribe News & Network Status:
RSS Subscribe Scheduled Maintenance: SQL Server Migration
Posted on 27/10/11 02:37PM

Our SQL 2000 Service, mssql.mydns.net.nz will be retired on Friday 18 November 2011. This decision has been made because SQL 2000 is over 10 years old and we can no longer support the software, or the hardware providing the service. All current SQL 2000 databases will be migrated to a replacement server running the latest version of Microsoft SQL, SQL 2008 R2 unless we are advised otherwise.

There will be an outage for all customers during the migration, this is scheduled to take place at the time & date below:

Impacted System: MSSQL.MYDNS.NET.NZ
Start Time: 18/11/2011 00:00 NZDT
End Time: 18/11/2011 04:00 NZDT

Connectivity:
All customers should be using the DNS name (connection string) mssql.mydns.net.nz to connect to their database. No other connection string is supported. The IP address that this resolves to will be moved to the replacement server at the time of the migration. The following legacy DNS aliases will be updated and will continue to work, however these will be retired in the medium term and should not be used.

winbox.mydns.net.nz
webadmin.mydns.net.nz

Impact:



Access to databases on mssql.mydns.net.nz will be unavailable during this maintenance window. Websites attempting to retrieve information from databases on this server during this time will return an error. No data will be lost. All databases will be backed up and transferred to the replacement server.
The majority of customers should not notice any change once the databases have been migrated to SQL 2008 R2, apart from improved performance. Databases will be left in SQL 2000 compatibility mode to minimise disruption. You may change this setting on your database after the migration to take advantage of the new functionality provide by SQL 2008 R2. We have identified a limited number of customers whose databases will have compatibility issues with the new version and they will be contacted directly. We would however advise all customers to check that their database will be compatible with SQL 2008 R2. You can do this by testing a copy of your database on your own SQL 2008 R2 instance, or by using the test instance we have setup as detailed below.

Testing:

Customers wishing to test their database in advance can do so using a copy of their database which has been restored onto a temporary SQL 2008 R2 instance. This database will be restored from 25/10/2011. The test instance can be connected to using the address below. The instance will only be available up until the day of the migration and is provided for testing purposes only.

sql2k8r2test.mydns.net.nz

We thank you for your understanding while this work is completed, and apologise for any inconvenience caused. Please do not hesitate to contact us should you have any queries.




If you would like to receive server announcements and latest news, please subscribe to our new RSS Newsfeedss below. Most of the latest browsers such as Firefox , Internet Explorer and Opera now have inbuilt RSS newsfeed readers, as does most good email software.



All prices exclude GST unless otherwise stated. Errors and omissions excepted.
© Copyright Lounge Network, a division of Design Lounge Ltd 2001-2018