Answer / 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

How can you stop stored procedures from recompiling?

0 Answers  

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

what is sql injection in sql server?

2 Answers   TATA,

---

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

---

What is mean by "fill factor" ? and what is mean by "Index "in sql?

1 Answers   iGate, Logica CMG,

---

Define inner join in sql server joins?

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

What is the temp table?

0 Answers  

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

---

Define msdb database?

0 Answers  

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---