I'm new to SQL Server...running SQL Server 2000. Had to move the system database logs to a different drive. Used EM, Server properties, Startup parameters. Changed the transaction log designation. Closed that window. Stopped the server.
Server won't start as I messed up and did not include the file name in the new designated path...just down to directory level.
From what I've seen, I have to be able to start the server service to change the parameters and the server won't start.
Is there a file that contains these parameters I may edit or should I try using the command line options.
Many thanks in advance.Was able to do a reg edit on the parameters and have it running.|||You can also start it from a command line with parameters.
sqlservr [-sinstance_name] [-c] [-dmaster_path] [-f]
[-eerror_log_path] [-lmaster_log_path] [-m]
[-n] [-Ttrace#] [-v] [-x] [-g number] [-O] [-y number]
Look at SQL BOL for the complete reference. It's a handy thing to know at 2:00am.
Regards,
hmscott|||I'm new to SQL Server...running SQL Server 2000. Had to move the system database logs to a different drive. Used EM, Server properties, Startup parameters. Changed the transaction log designation. Closed that window. Stopped the server.
Server won't start as I messed up and did not include the file name in the new designated path...just down to directory level.
From what I've seen, I have to be able to start the server service to change the parameters and the server won't start.
Is there a file that contains these parameters I may edit or should I try using the command line options.
Many thanks in advance.
Just a note: sometimes the paramters, when used in conjunction with other parameters, will act in an unpredicatable way. use google for more info|||just another reason to script everything.|||just another reason to script everything.
a real reason to script everything? all these sex ads (http://www.napstergirl.com) floating around the internets. I once thought that it was cool, but think of all the space this is wasting? anyway, this one ad kinda made sense to show cause look at the website: it is so advanced and could be used for other things
Showing posts with label startup. Show all posts
Showing posts with label startup. Show all posts
Saturday, February 25, 2012
Question on changing startup parameters
Subscribe to:
Posts (Atom)