SQL Server replication

What are the advantages and disadvantages of merge replication?

Advantages

• It provides built-in and custom conflict resolution capabilities.
• It allows for the synchronization of data from multiple tables at one time.
• It provides rich data replication options like selection of article types and filtering and identity range management.

Disadvantages

• Merge replication requires more configuration and maintenance at the server

SQL Server replication

What is Replication and Database Mirroring?

Database Mirroring allows two copies of a database on different computers. Clients can get access to only one database called as”principal” database. Any changes applied to principal database, are applied on the copy also called as the mirror. This is achieved by applying the transaction log for every insert, update, or deletion made on the primary database. This increases the availability of a database incase of a failure.

Reporting service interview questions

SQL Server reporting service -

Explain the architecture of SQL Reporting service.

Reporting Services runs as a middle-tier server, as part of your existing server architecture.

SQL Server 2000 should be installed for the database server, and Internet Information Services 6.0 as a Web server.

The report server engine takes in report definitions, locates the corresponding data, and produces the reports.

Interaction with the engine can be done through the Web-based Report Manager, which also lets you manage refresh schedules and notifications.

End users view the report in a Web browser, and can export it to PDF, XML, or Excel.