What has been your experience, if any using this utility? Is it a last resort thing? I recently ran it to repare the master db and now all my user database no longer appear. I'm sure I can reattach them though. Should I also restore the backup copy of master db that was last known good? All my maintenance plans, etc, no longer appear.
Any ideas why the master could become corrupt?
During execution of rebuildm I receive the following
errors logged to the cnfgsvr.out file:
driver={sql
server};server=AGRTESTDB;UID=sa;PWD=;database=mast er
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General
network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
ConnectionRead (recv()).
My server is down; anyone have any information on this
error and how to continue rebuild? (Alternatively of
course I could simply reinstall SQL.)
Thx,
Al
.
I cannot start my SQL 7.0 database server. It is a virtual server on a cluster.
I wish to use rebuildm.exe to build a system table and apply a restore.
How does this effect my clustered database.
Does changes to the undelying databases propagate to the virtual clustered database.
Will it render my virtual database useless.
I need help on this matter.
HELP
We are preparing Disaster recovery plans, and I need to recover the SQL servers. When testing this, I have run REBUILDM, and then set sql to single user and attempted restore of master. I receive error messages:
"2001-11-16 15:36:24.33 spid6 Getpage: bstat=0x9, sstat=0x1, cache
2001-11-16 15:36:24.34 spid6 pageno is/should be: objid is/should be:
2001-11-16 15:36:24.34 spid6 (1:988)/(1:988) 6/30
2001-11-16 15:36:24.84 spid6 ... IAM indicates that page is NOT allocated to this object
2001-11-16 15:36:24.88 spid6 Error: 605, Severity: 21, State: 1.
2001-11-16 15:36:24.95 spid6 Error: 3151, Severity: 21, State: 0
2001-11-16 15:36:24.95 spid6 The master database failed to restore. Use the rebuildm utility to rebuild the master database. Shutting down SQL Server.."
Subsequent attempt cause the same, UNLESS i reapply SP2 (the version running when the Master was backed up)
Is this a requirment or am I missing something??
Thanks in advance
Hello All.
I tried to test Rebuildm.exe on my local server
1. Stoped Sql
2. Renamed master.mdf to master.mdf_old
3. Tried to start Sql (Does start of couse)
4. Run Rebuildm.exe ... and "Gonfigurating Sql server" message goes forever (I was waiting 1 1/2 hrs ... progress bar was running )
Do I miss some some steps ?
Tnanks