| Author |
Topic |
|
fqiao70
Yak Posting Veteran
52 Posts |
 Posted - 2003-07-08 : 15:58:13
|
| Hi, I want to know what command file can shutdown and startup the sql server. I want to schedule the reboot sql service every night!Thanks!!!!!!!!!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-08 : 16:00:41
|
| Why would you want to do this? Is this production? If it is, bad idea. Anyway, to answer your question:NET STOP MSSSQLSERVERNET START MSSQLSERVERRun the above in a cmd window.Tara |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-07-08 : 16:00:42
|
| I didn't realize this was such an exciting topic!Read up on the NET START/STOP commands available from the command prompt.Jonathan{0} |
|
|
|
fqiao70
Yak Posting Veteran
52 Posts |
Posted - 2003-07-08 : 16:03:37
|
| oh, we have tape backup copying every night. so I want to stop the service for an hoursThanks |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-07-08 : 16:12:26
|
| There are many reasons you don't want to do this. Performance will suffer b/c the procedure cache and any pinned tables will go away.SQL Server does perform online backups, if you're doing this out of concern that it doesn't.Jonathan{0} |
|
|
|
fqiao70
Yak Posting Veteran
52 Posts |
Posted - 2003-07-08 : 16:19:14
|
| it's reasonable. could you give more detailed disadvantage sothat we will not do tape backup.thanks |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-07-08 : 16:31:39
|
| Why no make backups of your database(s) to disk, and have the tape backup those files?-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-04-07 : 12:00:50
|
| I have that same problem at my shop. The operation guys backup by tape and this cause them to stop the SQL server. I try and tell them there is no need for this but they are saying that it allows them the benefit to clone a new hard drive if it crashes. I know if I backup my databases then I can always restore. Not sure how to convince them. Any ideas?All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-07 : 12:11:32
|
| You just put your foot down and say database backups will be performed by SQL Server to disk. Tape backups should copy the files to tape. It takes a while for them to get used to it. Usually they want to do it there way because they don't trust you.Tara |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-04-07 : 13:46:01
|
| Yes, either put your foot down, or raise it up to the level of a sensitive area very quickly. |
|
|
|
|
SQL server start and stop