What are the OS services that the SQL Server installation adds?
Answer Posted / maheswar reddy s
SQL SERVER - is for running the databases
SQL AGENT - is for automation such as Jobs, DB Maintanance, Backups
DTC - Is for linking and connecting to other SQL Servers
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what is the function of sql server agent windows service?
What is the difference between count () and rowcount ()?
What are the reporting services components?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is identity?
What is the use of “join” in sql server?
What is a data source file?
What is the default sql server instance name?
Explain syntax for viewing, dropping and disabling triggers?
What is delete query?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What do you understand by recursive stored procedures?
Can we deploy SSRS reports on our personal website?
What is replace and stuff function in sql server?
What do you mean by table and field in sql?