What is database replicaion? What are the different types
of replication you can set up in SQL Server?
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
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.
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
when does an alert gets signaled?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
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.
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
What are the different types of indexes available in sql server? : sql server DBA
What are the recovery models for a database? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Why would you call update statistics? : sql server DBA
how can you connect from 10g user to 11g user??
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Explain about your sql server dba experience? : sql server DBA