May 16, 2006 at 9:34 am
All,
I am trying to install SQL Server 2000 on a Windows 2003 Server.
I originally had SQL Server 2000 installed on a Windows 2000 Server but then the company decided they wanted to use Windows 2003 so the C: of the Server was rebuild with Windows 2003 O/S.
I was planning on re-attaching the user databases I have on the D: of the server when I had installed SQL Server but it now keeps on hanging.
I am pointing the SQL data directory on the install screen to the D:\Data, as far as I am aware this will simply overwrite the systems dbs in a subfolder called D:\Data\MSSQL\Data\? Is this true or is this what could be making the install hang?
Any help would be appreciated.
Regards
Carl
May 17, 2006 at 8:23 am
Try moving the master, model, msdb and tempdb files in the D:\Data directory to a 'holding' directory. If overwriting is the issue you will soon know.
If you need the data in those tables (e.g. DTS pkgs, jobs, etc.) you can copy them back (assuming the same server name is being used) after applying all of the Service Packs, Hot Fixes, etc. that were on the original server.
May 17, 2006 at 9:58 am
Thanks for the reply.
I actually removed the files and was able to re-install without problems. I am still confused as I managed to uninstall and re-install SQL Server before without having to move/delete the systems databases.
Regards
Carl
May 17, 2006 at 12:23 pm
Is there any possibility that they were inadvertently set to read-only (NTFS attribs not SQL)? That would be the only reason I can think that the installer couldn't overwrite them.
May 18, 2006 at 3:12 am
I'm not sure whether they were set to read-only but I fully expected them to be overwritten myself.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply