(Continued from previous part...)

Database administration (4)

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

Replication is the process of copying/moving data between databases on the same or different servers. SQL Server supports the following types of replication scenarios: ? Snapshot replication ? Transactional replication (with immediate updating subscribers, with queued updating subscribers) ? Merge replication See SQL Server books online for indepth coverage on replication. Be prepared to explain how different replication agents function, what are the main system tables used in replication etc.

What is the system function to get the current user’s user id?

USER_ID(). Also check out other system functions like USER_NAME(), SYSTEM_USER, SESSION_USER, CURRENT_USER, USER, SUSER_SID(), HOST_NAME().

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

Types of backups you can create in SQL Sever 7.0+ are Full database backup, differential database backup, transaction log backup, filegroup backup. .....

What is a major difference between SQL Server 6.5 and 7.0 platform wise?

SQL Server 6.5 runs only on Windows NT Server. SQL Server 7.0 runs on Windows NT Server, workstation and Windows 95/98.

Is SQL Server implemented as a service or an application?

It is implemented as a service on Windows NT server and workstation and as an application on Windows 95/98.

What is the difference in Login Security Modes between v6.5 and 7.0?

7.0 doesn’t have Standard Mode, only Windows NT Integrated mode and Mixed mode that consists of both Windows NT Integrated and SQL Server authentication modes.

What is a traditional Network Library for SQL Servers?

Named Pipes.

If you encounter this kind of an error message, what you need to look into to solve this problem?

[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL Server not found.
1. Check if MS SQL Server service is running on the computer you are trying to log into
2. Check on Client Configuration utility. Client and Server have to in sync.

(Continued on next part...)