Interested to Buy Any Domain ? << Click Here >> for more details...
what are the problems in logshipping?
- 3 Answers
- 21896 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / chhavi...sql server dba_431,44
Let me rephrase it first...Limitation in logshipping...
1. Automatic failove is not possible.
2. There will be some data loss because you can't configure
the backup job to run less than 2 minutes.
But insted of these limitation we have many advantages:
1. We can configure the restore job to run with sufficint
delay to recover from user's error.
2. We can have more number of secondaries
3. Also provide log backup backup which can be utilize in
point in time recovery
| Is This Answer Correct ? | 21 Yes | 2 No |
Answer / parker
Logshipping is a new feature of SQL Server 2000. We should
have two SQL Server - Enterprise Editions. From Enterprise
Manager we can configure the logshipping. In logshipping
the transactional log file from one server is automatically
updated into the backup database on the other server. If
one server fails, the other server will have the same db
and we can use this as the DR (disaster recovery) plan.
| Is This Answer Correct ? | 28 Yes | 12 No |
How to transfer a table from one schema to another?
What is the difference between char, varchar and nvarchar?
State the difference between local and global temporary tables?
What kind of problems occurs if we do not implement proper locking strategy?
what is the maximum size of sql row in mssql?
What are window functions in sql server?
What will be the maximum number of indexes per table?
Normalization and denormalization
What is the difference between deallocate cursor and close cursor?
What are out-of-range errors with date and time literals?
What are commonly used mssql functions in php?
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
