open the sql query and execute this code for backup

BACKUP DATABASE dbname TO DISK='C:\dbbackup\backupfile.bak'

and load it from another server!

USE master
GO
DROP DATABASE dbname
GO
RESTORE DATABASE dbname FROM DISK='C:\dbbackup\backupfile.bak'

very simple, isn’t it? also there are many and many other backup options worth for check.

there are some critical bug(?) in cygwin. if you upload some files using cygwin’s ssh protocol, the files’s permission are -rwx—— by default, it causes operation system error. so you have to change the permission to -rwxrwxrwx. not only db backup file, even just a plain asp file can’t be opened. so don’t miss it.

i stucked on some mysterious error today. i made some xml config in struts.xml, it’s very simple one and there’s nothing wrong as far as i knew

<action name="someurl" class="someAction" method="list" >
	<result>/WEB-INF/pages/someurl.jsp</result>
</action>

and i got this error

Could not find action or result
No result defined for action com.fri13th.SomeAction and result input

of course i checked and checked all the parameters again. there was no mistake at all.. so why it didn’t work?

then i make another class and check again. it works fine. so what the difference was? the only difference was annotated validation in front of class definition. i deleted some validation code and it worked fine..

i’m too tired today, must go to bed early than usual..