Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take?
Answer Posted / hari
first you rebuild the master db by using REBUIDM.exe. after
u take single user mode Sqlservr.exe -c -m.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the steps to create and execute a user-defined function in the sql server?
Do you know what are various aggregate functions that are available?
What do you understand by replication in sql server?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What is the difference between the 2 operating modes of database mirroring?
When columns are added to existing tables, what do they initially contain?
How you can add messages to the nt event log from within a stored procedure?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Difference between LEN() and DATALENGTH() in sql server ?
How to select some specific rows from a table in ms sql server?
What is field in algebra?
Is INSTEAD OF trigger directly applicable to Table ?
How to update values in a table with update statements in ms sql server?
What is the difference between left and right outer join?
What is the difference between ‘having’ clause and a ‘where’ clause?