locked
Backup Microsoft SQL 6.0 RRS feed

  • Question

  • Hi there

    I have a old MS SQL 6.0 Server. I wanted to do a full backup and migrate to MS SQL Express!
    My objective for now is to find guides on how to backup MS SQL 6.0. Anyone can enlighten me as I can't find a guide/tips on this area.

    MS SQL
    Version: 6.0.0.121


    Many thanks.

    Regards,
    makan007
    Monday, September 10, 2007 3:47 AM

All replies

  • Wow - interesting. To get to SQL Express you need to come from no earlier than 7.0 - upgrade from 7.0 to 9.0 (SQL Server 2005) is the most backward-looking upgrade path that's supported. I discussed how to get to 7.0 with my wife Kimberly Tripp, as it's before my time, and she advises installing 7.0 and then using the migration wizard from 6.0 to 7.0 - if that's supported. One issue you have is that nothing that old is supported at all, so if you run into any issues you'll have a hard time finding support. I know some people in Product Support who were around then - let me know if you hit any problems and I may be able to to get you some limited help.

     

     

    Monday, September 10, 2007 5:15 AM
  • What I meant was I am going to restore my SQL 6.0 data to another server (w/ MS SQL Express). Will there be any issue?
    Tuesday, September 11, 2007 7:41 AM
  • Yes - you can't directly attach/restore a 6.0 database to a 2005 server without first upgrading it to 7.0 as there's a big conversion that has to take place between 6.5 and 7.0.

     

    Thanks

     

    Tuesday, September 11, 2007 1:17 PM