Thursday, September 25, 2008

Smooth move from SQL Server 2008 RC0 to RTM

Recently we performed a Backup-and-Restore from SQL Server 2008 Standard RC0 to another server installed with SQL Server 2008 Standard RTM.
Overall it only took 30~60 minutes for the entire process, and I am glad for Red Gate's SQL Backup (for compression)

  • Backup & Compress databases on RC0
  • Copy over network for shorter time
  • Uncompress (using SQL Backup to MTF Converter)
  • Restore on RTM
  • Cleanup (update stats, index reorganize, associate logins, SQL jobs, etc...)

1 comment:

  1. You should be aware of HyperBac for SQL Server as well, it provides the equivalent compression and performance to Red Gate, but with a completely different architecture which allows you to achieve on the fly SQL backup compression using all native commands and procedures (no xp's or third party guis), also is extensible to many other applications in SQL