Answer Posted / Nisar Ahmad
Database states in MS SQL Server include:n- Running: The database is available for connections.n- Restoring: The database is being restored.n- Offline (single user mode): The database can be accessed by a single user, useful for repairing or recovering data.n- Recovery pending: The database is in the process of recovery after an outage.n- Suspect: The database has encountered errors and needs to be checked and possibly repaired.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is standby servers? Explain types of standby servers.
Why should you use or avoid select * statements?
How do I create a trace in sql server?
How to provide default values to function parameters?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is sql or structured query language?
What are the properties of the transaction?
List out the different types of locks available in sql server?
Why use identity in sql server?
do you know how to configure db2 side of the application? : Sql server database administration
Can you index views?
What are the different SQL Server Versions you have worked on?
What is in place upgrade in sql server?
What is normalization and what are the advantages of it?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
