Answer Posted / d patel
- Logshipping failover is not automatic process. DBA must
sitll muanually do. that means DBA must be present when the
failover occurs
- The users will experience some downtime. How long depends
on how well you implement log shipping
- Some data will be lost
- The database that are being failed over to the standly
server cannot be used for anythings.
| Is This Answer Correct ? | 39 Yes | 7 No |
Post New Answer View All Answers
Explain the disadvantages/limitation of the cursor?
What are the differences between local and global temporary tables?
What is query optimizer in sql server?
What does it mean to be in union?
Detail about the hardware which is supported by SQL server?
Can you pass expressions to function parameters?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Explain transaction server isolation?
Explain Capacity planning to create a database? and how to monitor it?
What are sub reports and how to create them?
Explain aggregate functions?
What is policy management?
Explain syntax for dropping triggers?
What are the types of lock supported by ?
Explain about the command-line tool SQLCMD?
