Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why people hate cursor?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
How to end a stored procedure properly in ms sql server?
What are the advantages of partitioning?
Explain the steps needed to create a scheduled job?
Can a cursor be updated? If yes, how you can protect which columns are updated?
Please explain go command in sql server?
Scalability, Availability, Integration with internet, etc.)?
what types of replication are supported in sql server? : Sql server database administration
What is exporting utility?
What are the ways available in sql server to execute sql statements?
When we should use and scope of @@identity?
What do you mean by sql server agent?
Can I save my report as html, excel or word? : sql server management studio
What are the benefits and tasks of object explorer? : sql server management studio
