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
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is sql server programming?
How to use linked server?
What command would you use to add a column to a table in sql server?
What are the different kinds of ssrs reports?
Mention the 3 ways to get a count of the number of records in a table.
What is sqlcmd?
What are the drawbacks of reporting in ssrs?
Can foreign key be deleted?
What kind of problems occurs if we do not implement proper locking strategy?
What is a transactions?
Define tool Manage Statistics in SQL Server 2000 query ?
Explain trigger and its types?
What is a result set object returned by odbc_exec()?
Explain temporary table vs table variable by using cursor alternative?