December 9, 2003 at 12:32 am
I have a small problem. I started rebuilding my master database in one of my experimental servers through rebuildm utility. after copying files from cd to disk it is continuously showing
Configuring server -- Server configuration progress and the tabs are simply moving from left to right continuously. It ran for 7 hours and is still in the same state at the time of sending this mail
I didn't change the collation setting. i tried on another experimental server. similar case there too. why is it so? do I need to do anything specific? i had stopped sqlserver, sqlagent and msdtc before this exercise. usually how much time master rebuild may take on an average? kindly tell me a solution to this problem
December 9, 2003 at 5:54 am
Did you change the file attributes on the files that you copied from CD to take off read only?
December 9, 2003 at 10:12 pm
thanks lindr, i didn't do that. rebuild utility being an automated process, I din't intervene in between. do i need to stop it once file copying is over, change attributes of copied files and then how to resume from that point onwards? pl help
December 10, 2003 at 7:17 am
You'll need to stop it manually. Proper steps are:
1) Copy source folder off of CD (\x86\data)
2) Remove Read-only attribute from folder and files
3) Run rebuildm.exe
The issue is a known bug (but not well-communicated) that just about everyone runs into the first time they try a rebuildm (have the t-shirt myself). Microsoft has documented it here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;273572
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply