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
What is RAID? What are the different types of RAID configurations?
Explain concepts of analysis services?
What is NOT NULL Constraint in sql server 2012?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What are “unrepeatable reads”?
How you can minimize the deadlock situation?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is the difference between update lock and exclusive lock?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What are database states in ms sql server?
What is triggers in ms sql server?
Mention the command used to rename the database.
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How to provide login information for a new odbc dsn?
what are the different types of replication you can set up in sql server? : Sql server database administration