Upgrading from SQL7 to SQL2K Issues

  • I am having 2 issues with my current upgrade to SQL2K from SQL7. First, a little background information:

    We just installed a new Database server running Win2K and applied all updates to that box. We then installed SQL2K and applied SP3a. The base installations are completed on new system.

    On the old database server, we had an issue where the log files were being recorded on a seperate drive but it ran out of space, so I had to add a second location where the log file could span to if it needed extra space. This is causing a problem with the database restore methods I am using.

    I am backing up the database from SQL7, move the flat file from the SQL7 server to the SQL2K server and restoring it on SQL2K. I get an error message about File Activation error on the MDF and 2 LDF files in the backup set. I need to use the 'WITH MOVE' option but cannot find it anywhere.

    If I try to use a DTS from the SQL7 database to the SQL2K, I cannot force the table owner name to be set correctly.

    I do not know what I am doing wrong. Can someone please help?

     

     

  • Woops...

    Found the problem. Thanks anyway!

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

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