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
How to name query output columns in ms sql server?
What do you understand by hotfixes and patches in sql server?
what are the different types of SSRS reports?
What is difference between table aliases and column aliases? Do they affect performance?
How many types of the database links?
What is the fastest way to permanently delete a 1 million row table named customers?
How to create a user to access a database in ms sql server using "create user" statements?
What is partition index in sql server?
What Is Rdbms?
If a table does not have a unique index, can a cursor be opened on it?
Does the order of columns in update statements matter?
How to set database to be read_only in ms sql server?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Name few endpoints exposed by ssrs 2012?
What is auditing in sql server?