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 is diffence between replicaion and logshipping?

Question Posted / prasadhari_m@yahoo.com


what is diffence between replicaion and logshipping?..

Answer / hari

Log shipping is the different than the Replication .

Logs can be shipped to stand by server. where the database
should be in non-recovery or standby mode.you can you have
stand by server ready when failure of primary server occurs
or you can even use standby server for read only adhoc
queires by users in your organization to distribute load
and also use the same server in event of main server failure

As per replciation there are 3 types of repliciation .
Depending on the transcations being performed and the
requirement you implement it.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What are commonly used mssql functions in php?

0 Answers  

What is policy management?

0 Answers  

How do I find the sql server database version?

0 Answers  

How to enter date and time literals in ms sql server?

0 Answers  

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  

Explain DBMS, RDBMS?

6 Answers  

What are the different types of sub-queries?

0 Answers  

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

What is dml command?

0 Answers  

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

Explain magic tables in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories