ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
what is diffence between replicaion and logshipping?
 Question Submitted By :: Prasadhari_m@yahoo.com
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is diffence between replicaion and logshipping?
Answer
# 1		 
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 0 No
Hari
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?  5
How to find the date and time of last updated table?  3
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server. IBM4
Can we create clustered index on non primary key column CTS14
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?  1
How do you persist objects, permissions in tempdb  1
About DTS usage ? Cognizent2
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha  4
what is a stored procedure and trigger?  2
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.  7
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them? Techno-Solutions1
i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj IBM7
what is extended StoreProcedure ? Satyam3
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person  7
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?  2
What all db objects can be found in MSDB database of a SQL Server instance? Accenture1
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
What is the difference between Userdefined function and stored procedure? Explain and give the example also  4
What is ACID Property of Transaction?  4
How do SQL server 2000 and XML linked?  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com