Post reply

Master database import in SQL Server 6.5

  • January 30, 2002 at 9:05 am

    #58018

    Hello

    On a SQL Server 6.5, I export the master database and try to import it to another SQL Server 6.5.

    OK for the export (200Mo dumped to a 15 Mo file). I run SQL Server 6.5 in single user mode (sqlservr -c -m), select master database in Enterprise manager, select restore/from file, select the exported file and go for a restore

    And here is the problem

    Data on dump will not fit into current database. Need 117M database

    The master database device was 200 Mo in size (like the first), I expand it to 500 Mo and I've always the same error at the restore

    Does anyone know the solution of this problem

    Thank you

  • January 30, 2002 at 9:35 am

    #422869

    The databases mus be defined as the same size with the same number of devices in v6.5. So the new v6.5 master you create must be EXACTLY the same as the ones you dumped.

    Steve Jones

    steve@dkranch.net

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

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

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