June 27, 2006 at 6:36 am
I need to rebuild the master database on a server that has SQL Server 2005 as the default server(instance?) and SQL Server 2000 as an instance.
I look in the folder Program Files\Microsoft SQL Server\80\Tools\Binn for Rebuildm.exe and it is not there.
My guess is that SQL Server 2005 was the first server installed and then the 2000 instance and that may be why the rebuild program is not there.
Can I just copy Rebuildm.exe from any SQL Server 2000 instance we have, place it in that folder and run it? Or will that just give me more problems?
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
June 27, 2006 at 9:56 am
1. Right now you have SQL 2000 and SQL 2005 installed on this machine?
2. if you have *only* rebuildM.exe missing, you can safely copy (make sure that source server has same build as current SQLServer.exe on destination)
June 27, 2006 at 1:34 pm
Thanks!
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
June 28, 2006 at 9:20 am
Rebuilding "Master" in 2005 is not the same as 2000. You actually need to run "setup" to rebuild it. Rebuildm does not exist in 2005. See BOL for Rebuilding Master for more information. Although the command looks simple, it can be tricky.
Hope this helps!
Rick...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply