Sunday, June 13, 2010

Script Samples

There are times when I spent an inordinate amount of time looking for just the right syntax for a command or even the correct command to get the job done. Here are four I put to use in the last few months...

Change Printer Spooler Service Recovery options to Restart
sc failure spooler reset= 60 actions= restart/600/restart/600/restart/600

Backing up an MSDE Database
osql -E -Q "BACKUP DATABASE mdss TO DISK= 'C:\BB_DB_Backup\mdss.bak'"

Copy Database and then Appending with Date
copy t:\plandata.mdb C:\PlanDataBackup /Y

For /F "Tokens=1-8 Delims=.:/ " %%a In ('Echo %Date%') Do (Set All=%%d-%%b-%%c)
@For %%a in ("plandata.mdb") do rename %%a "%%~na-%All%.mdb"

Deleting Old OWA Logs
forfiles -p "C:\inetpub\logs\LogFiles\W3SVC1" -c "cmd /c echo del \"@FILE\" & del \"@FILE\"" -d -21

No comments:

Post a Comment