원초적 backup

원초적인 하드 백업 정책.
정적한 시간대에 배치파일을 예약스케쥴 걸어놓고..

[backup.bat]


net stop sqlserveragent
net stop mssqlserver

xcopy D:\MSSQL\Data E:\MSSQL\Date /S /E /R /H /K /A /C /Y

net start mssqlserver
net start sqlserveragent


net stop "World Wide Web Publishing Service"

xcopy D:\www e:\www /S /E /R /H /K /A /C /Y

net start "World Wide Web Publishing Service"