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 >> DB Administration
  2. Suggest New Category

What is database replicaion? What are the different types
of replication you can set up in SQL Server?

Question Posted / kishor

Answer Posted / kishor

move/copy of the data from one server to another server is
call replication
types of replication

1.snapshot
2.merge
3.transactional
4.transactional with up-datable subscription(newly added in
sql server2005)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2204

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

963

when does an alert gets signaled?

994

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1065

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1948

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1892

What are the different types of indexes available in sql server? : sql server DBA

1121

What are the recovery models for a database? : sql server DBA

1075

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1058

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2659

Why would you call update statistics? : sql server DBA

953

how can you connect from 10g user to 11g user??

2069

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1923

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

996

Explain about your sql server dba experience? : sql server DBA

1036