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.
winnt.exe is used to start an over-the-network installation of Windows 2000.
Windows 2000 includes a powerful tool to manage disks - it's called Disk Management. You can use Disk Management to create and manage several different volume types on a Windows 2000 computer.
To achieve optimum functionality of the client computers, you must upgrade all of them to Windows 2000. Upgrading some of them and/or installing the Directory Service Client will gain some functionality, but the question specifically states that "optimum functionality" is the required result.
Copyright ©CuriousTab. All rights reserved.