October 9, 2009 at 2:47 am
can u give the clarification please
1) Master Database was corrupted. But we have backups available. How to restore the master database back up.?
Discussion:- When master database is cor reputed. we can able to run the sql server. because sql server will run depends up on the master database.
we can't able to run in single user mode also.
Backup restore will possible by running sql server. If Sqlserver not run how we can get restore the backup.
So finally how we can restore the master database from back up file.
2).In log shipping one LSN back up file didn't copy and restore in secondary server. Means we will get one error in log file.
one LSN number backup was not copied and restored. Then what you will do?
Please let me know the answers as soon as possible
Thanks in advance
October 9, 2009 at 2:57 am
Hi Siva,
You cannot run SQL server if master is corrupted . You need to run SQL Server in the single-user mode and then you can restore the master database.
You will get the last backup taken and restored from tables LOG_SHIPPING_MONITOR_PRIMARY and LOG_SHIPPING_MONITOR_SECONDARY respectively
October 9, 2009 at 3:37 am
Assuming you are using SQL Server 2005:
When the master database is damaged it must be rebuilt if,
A current backup is unavailable or,
A backup exists but can't be restored because, the instance of SQL Server will not start.
To rebuild a master database run from the command-prompt,
start /wait D:\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<new_strong_password>
1. Then, restore recent full backups of the system databases.
2. If a restored backup of the system databases is not current, recreate any missing entries.
3. Reapply any SQL Server Updates.
In SQL Server 2000 the process is basically the same except instead of running setup.exe from the command-line you run Rebuildm.exe from the BINN directory.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply