raffie613
asked on
Batch file for auto backup
Can someone help me write a batch file to stop the SQL service, copy a data folder on my external drive and paste it to my desktop, then restart SQL service ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it should be something like SQLExpress instead.
Anyway you can know it either by issuing a :
tasklist /svc
on the command line.
Or running services.mscand right-click on the service. The name is the first field of the properties windows.
Anyway you can know it either by issuing a :
tasklist /svc
on the command line.
Or running services.mscand right-click on the service. The name is the first field of the properties windows.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok, and I write this batch file in Notepad? Where do I save it so it can run every night? How do I set the time that it should run?
save it wherever you want and then set up task manager from administrative tools/task scheduler as shown here
ASKER