Post reply

Moving Database to another server with a 64 bit OS

  • November 20, 2008 at 6:23 pm

    #201648

    I am having a problem I need to move the sql express 200 to a new server, the server is running 64 bits OS, and the old server is running 32. I move the database and I attach with no problem then I replace the master.bak using the sqlcmd that works good as well, but the service stops and I get an error when trying to start the service:

    event id : 17207

    FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\mssqlsystemresource.ldf'. Diagnose and correct the operating system error, and retry the operation.

    it is looking for this file on 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\mssqlsystemresource.ldf' on this directory but the new one is on 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\Data\mssqlsystemresource.ldf'

    I already tried to install it on the regular program files but with no luck it will install it on the (x86)

    please help I am getting fustrated, I cant run the alter database since the SQL instance is not running.

    Thanks in advance

  • November 20, 2008 at 9:10 pm

    #901416

    The system resource database must be in the same place as master. Where did you place the new master database?

    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

  • November 21, 2008 at 10:31 am

    #901760

    I placed it at C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\Data\ but it comes from a server that had it in the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\Data

    Thanks

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

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