Amount of time for a REBUILDM to complete

Question

Amount of time for a REBUILDM to complete

Terry Barkoulas

SSC-Addicted

Points: 437
More actions
April 7, 2005 at 12:04 pm

#164068

Guys as an experiment, I decided to delete all databases on the SQL server in my lab and attempt to rebuild using REBUILDM. I performed a clean install of SQL server, and created a couple of databases and backed them all up to disk via EM, blew them all away and started the REBUILDM process. Now it's been more that an hour and it still isn't done yet.
How long should this take and has anyone ever had success with this tool? I tend to think a re-installation of SQL server makes a lot more sense.
Regards
Terry

Viewing 6 posts - 1 through 5 (of 5 total)

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

athurgar SSCrazy Points: 2816 More actions · Answer 1

Terry,

I have used rebuildm to change the sort order on an incorrectly built server - took less than 10 minutes and then I just had to reattach the user databases. You would be wise to script out all logins, save DTS packages and jobs.

Make sure that SQL Server is stoped and you run rebuildm from the command prompt. You may also need installation media.

Hope this helps.

Adam

Martin Mojzisek SSCrazy Points: 2207 More actions · Answer 2

There's a known issue with rebuildm if you point it to database files located on install cd. Try copying the files to disk, make sure that they don't have read-only attribute set and point rebuildm to location on disk. It's been a long time since I tried that but I remember that once it worked and for the second time, it kept hanging and I had to reinstall the whole server.

Kishore-132325 Hall of Fame Points: 3784 More actions · Answer 3

Thats right Martin. To rebuild you need to first copy the \Data folder, remove the read-only atttribute from all the files and folder and then run the rebuildm.exe from the \Data folder on the disk. I have experienced this before. But after you have set the attribute, it works fine within 10-15 mns.

--Kishore

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 4

Here's the link to the KB (BUG) article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;273572

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Terry Barkoulas SSC-Addicted Points: 437 More actions · Answer 5

Thank you Martin, you are correct. I copied the files from the CD to a local drive and ensured that the read-only attribute was removed. The REBUILDM process worked like a charm.

Regards

Terry