logo

CuriousTab

CuriousTab

Discussion


Home Certification Microsoft Certification See What Others Are Saying!
  • Question
  • You are the administrator of a SQL Server 2000 computer. You configure SQL Server to perform C2 auditing. Audit logs are saved in the C:MSSQLAudit folder.The server functions normally for several days, but then the MSSQLServer service shuts down without warning. You cannot restart the service.You need to restart the MSSQLServer service. What should you do?


  • Options
  • A. Start the MSSQLServer service manually by using the -m startup option.
  • B. Start the MSSQLServer service manually by using the -s startup option.
  • C. Set the SQLServerAgent service's startup method to Disabled. Start the MSSQLServer service.
  • D. Delete the audit logs from the C:\MSSQL\Audit folder. Start the MSSQLServer service.

  • Correct Answer
  • Delete the audit logs from the C:\MSSQL\Audit folder. Start the MSSQLServer service. 

    Explanation

    SQL Server functioned for several days but now it is impossible to start it.
    The most likely cause is the size of the auditing log files. The maximum file size for the audit log is fixed at 200 megabytes (MB). When the audit log file reaches 200 MB, a new file will be created and the old file handle will be closed. If the directory fills up, then the instance of Microsoft SQL Server is stopped. The system administrator needs to either free up disk space for the audit log before restarting the instance of SQL Server or restart the instance of SQL Server

    Note 1: SQL Server Agent monitors itself and the SQL Server service.
    SQL Server Agent can restart the local instance of SQL Server if it has terminated for reasons other than a typical shutdown.

    Note 2: Start the MSSQLServer service manually by using the -f startup option would start the service with minimal configuration. It could be used when some configuration errors have been made and the MSSQLServer service isn't able to start.


  • More questions

    • 1. Which two descriptions are correct about characteristics of IPv6 unicast addressing? (Choose two) A. Global addresses start with 2000::/3. B. Link-local addresses start with FF00::/10. C. Link-local addresses start with FE00:/12. D. There is only one loopback address and it is ::1.
    • Discuss
    • 2. What are the six OSPF route types?
    • Discuss
    • 3. How many non- overlapping channels are available with 802.11b?

    • Options
    • A. 3
    • B. 12
    • C. 23
    • D. 40
    • Discuss
    • 4. Which IEEE committee has been sanctioned by WAP and is called WPA2?
    • Discuss
    • 5. When a station sends a transmission to the MAC address ff : ff : ff : ff : ff : ff, what type of transmission is it?

    • Options
    • A. Unicast
    • B. Multicast
    • C. Anycast
    • D. Broadcast
    • Discuss
    • 6. In the operation of CSMA/CD, which host(s) have priority after the expiration of the backoff algorithm?

    • Options
    • A. All hosts have equal priority
    • B. The two hosts that caused the collision will have equal priority
    • C. The host that sent the jam signal after the collision
    • D. The host with the highest MAC address
    • Discuss
    • 7. What is the Classs A Private IP address space?
    • Discuss
    • 8. What is the Class C private IP address space?
    • Discuss
    • 9. To use VLSM, what capability must the routing protocols in use possess?

    • Options
    • A. Support for multicast
    • B. Multi-protocol support
    • C. Transmission of subnet mask information
    • D. Support for unequal load balancing
    • Discuss
    • 10. If you wanted administrators to see a message when logging into the router, which command would you use?

    • Options
    • A. message banner motd
    • B. banner message motd
    • C. banner motd
    • D. message motd
    • Discuss


    Comments

    There are no comments.

Enter a new Comment