March 18, 2004 at 9:10 am
I am atempting to move my databases to a new server. When I try to restore the master database on the new server, I get the message saying it will not restore because it is a different version. The old server has sp1 installed and the new one has sp3. Can I simply install sp3 on the old server and then have exactly the same versions so I can complete the master database restore?
The solution was easy. I just reinstalled and dropped back from SP3 on the dest server to SP1. Then all went fine. Except it made me apply SP3 before Windows Server 2003 would let anything connect to it.
March 18, 2004 at 3:54 pm
Yes, as long as SQL is loaded in the same location on both servers (IE the BINN and Master, MSDB, and TempDB are in the same drive locations on both servers). In order to restore master you will need to start SQL in single user mode (from CMD window run "SQLSERVR -m -f T3608" from the BINN folder). Microsoft Knowledge Base Article - 224071 http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2k describes how to move to a new location, but I have had issues doing this a couple of times and had it work a couple of times.
You may also want to look at: http://support.microsoft.com/default.aspx?scid=kb;en-us;314546&Product=sql2k HOW TO: Move Databases Between Computers That Are Running SQL Server. This is the way I have been doing it lately and it works.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply