Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what are the problems in logshipping?

Question Posted / guest

Answers were Sorted based on User's Feedback



what are the problems in logshipping?..

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

what are the problems in logshipping?..

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

what are the problems in logshipping?..

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

Post New Answer

More SQL Server Interview Questions

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

What are alternate keys?

0 Answers  

What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  

How to rebuild all indexes on a single table?

0 Answers  

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

What is the openxml statement in sql server?

0 Answers  

Explain log shipping?

0 Answers  

Difference between aggregate functions of sql?

0 Answers   EXL,

Explain the storage models of OLAP?

1 Answers  

What is Schema in Database?

1 Answers   Cap Gemini,

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories