Post reply

database upgrade

  • February 16, 2012 at 2:40 pm

    #264748

    I have a database that is on sql server 2000 server.

    I use backup and restore it to a SQL server 2008 server.

    Is that the right way to do it?

    Or should I use copy database wizard?

    which is better option, what else do I need to do?

    Thanks

  • February 16, 2012 at 3:05 pm

    #1448186

    Either works. Backup-restore is far less work and should be quicker.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 16, 2012 at 3:12 pm

    #1448191

    Thanks, yes I did the backup - restore option.

    I see after restore the database on the 2008 server, at the database property-options, compatibility level is SQL server 2000(80)

    My question is if use the copy database wizard option, does it have the same for compatibility, or it changed to SQL 2008(100)?

    I currently cannot test the database copy option, I got connection failed message.

    thanks

  • February 16, 2012 at 3:15 pm

    #1448194

    Can't remember.

    Doesn't really matter, it's just a compatibility setting, nothing more. You want it at 100, set it to 100.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 16, 2012 at 3:35 pm

    #1448203

    Thanks, I also find this article.

    http://www.networkworld.com/community/node/44827

  • February 17, 2012 at 10:09 am

    #1448637

    sqlfriends (2/16/2012)

    I have a database that is on sql server 2000 server.

    I use backup and restore it to a SQL server 2008 server.

    Is that the right way to do it?

    Or should I use copy database wizard?

    which is better option, what else do I need to do?

    Thanks

    Don't forget to run DBCC UPDATEUSAGE and DBCC CHECKDB. Also check the stats are up to date too

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 17, 2012 at 10:24 am

    #1448643

    Thanks all

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply