starting SQL server

[mlorencak]

Hi...

can anyone help me. I would like to start and stop SQL
server 7 from the command prompt. I need that to backup
"cold" files from SQL server. Is it mybe possible to put
database in that condition that nobody can reach it and
system release all files so I can backup that. This will
also be a solution for me.

lp, Mitja

 

[MaffewW]

you can stop and start services from the command line using

net stop mssqlserver
and
net start mssqlserver

Matt

Brighton, UK

 

[mlorencak]

Thanks..

it works. I noticed that I must start also service "sqlserveragent", because stoping mssqlserver
also stops this one.


lp, mitja