Interested to Buy Any Domain ? << Click Here >> for more details...
can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)?
- 1 Answers
- 4425 Views
- I also Faced
- E-Mail Answers
Answer Posted / bruhaspathy medishetty
Hi
Restoring Master Database is not a frequently done step. So
I can throw some light on this and you would understand
more based your knowledge in SQL Server.
I shall give a bried intro on this.
First, there is a change in restoring Master DB in SQL
Server 2000. When there is a need to restore Master DB, you
need to start the SQL Server from command prompt using the -
c -m startup flags and restore from a working copy of
Master database.
If the situation needs tou to repair the master database,
then you need to use rebuildm.exe under the tools directory
and rebuild a Master database first and then restart the
SQL Instance..
In SQL Server 2005 also the same steps of restoring can be
followed but in order to repair, you cannot rebuild the
master DB, you need to reinstall the SQL from the command
prompt using certain key words
as "/wait" "/qn" "REINSTALL" "REBUILDDATABASE" etc.
One final word of caution, when migrating from different
Server Names and Different Sever Editions, I dont think the
Master database backup of another Server can be used to
restore the master DB on the current Server. This is
because, the ServerProperties such as Edition Name, Server
Name and other details are all stored in Master DB and SQL
will fail to start if they do not match.
Thanks,
Bruhaspathy
www.learnsqlwithbru.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain logical operators in sql server?
What are scheduled tasks in sql server?
What do you understand by the data quality services in sql server?
What are the steps you can take to avoid “deadlocks”?
What is not null constraint?
What does it mean to normalize a database and why would you do it?
What are the different kinds of ssrs reports?
What are the advantages of policy management?
Explain the usage of floor function in sql server.
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Explain the difference between primary keys and foreign keys?
How to add an address record into adventureworkslt?
How except clause is differs from not in clause?
How can we remove orphan records from a table?
how to take backup bcp out for a column in table in sql server?
