Fixing an Incorrect Option Setting


Setting a value too high for a parameter might cause SQL Server to crash during startup. For example, if you set the value of the memory option to a value that is higher than the physical memory on the machine, SQL Server will not start. In this case, you start SQL Server with the -f option. This causes SQL Server to start with the default parameter values (the same values used by the setup program when you installed SQL Server). After SQL Server is running, change the incorrect value to the correct one and restart SQL Server without the -f option.



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net