Post reply

Moving database from named intance to default instance

  • January 25, 2011 at 2:28 am

    #232631

    Hi

    I'm currently working on moving a database from a named instance on SQL Server 2005 to a named instance on SQL Server 2008. Are there any issues or challanges I should be aware of before doing this? Or is this the same as moving from a named instance to another named instance?

    /Andy

  • January 25, 2011 at 3:03 am

    #1277686

    After moving change the compatibility to 100

  • January 25, 2011 at 4:36 am

    #1277718

    Akkare (1/25/2011)

    After moving change the compatibility to 100

    I wouldn't do this straight away without test that all the application code is compatible with level 100 first.

  • January 25, 2011 at 5:39 am

    #1277753

    The application that uses the database in developed in house, and the database only has 4 columns. But 8 million rows.

    So is shouldn't be any issues with supporting 10.

    /Andy.l

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

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