Hi
> can i be schedule run?
Sure, create a job with BACKUP DATABASE... command and schedule it

? how to restore?

Take a look at RESTORE DATABASE ....command in the BOL

?can you pls send me some reference
> for futher study.

Start with BOL (Books On Line ) which ships with SQL Server



"William Cheung" <chun_hei@msn.com> wrote in message
news:OEfjMPkAHHA.2316@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> can i be schedule run? how to restore? can you pls send me some reference
> for futher study.
>
> thx,
> William
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:%23SGqKKkAHHA.4808@TK2MSFTNGP03.phx.gbl...
>> Hi
>>
>>
>> See ,BACKUP DATABASE command in the BOL
>>
>>
>>
>>
>> "William Cheung" <chun_hei@msn.com> wrote in message
>> news:uC8T4DkAHHA.3380@TK2MSFTNGP04.phx.gbl...
>>> Dear,
>>>
>>> i want to backup the SQL Server while without advance backup
>>> software(CA, symantec...).
>>>
>>> reg,
>>> William
>>>
>>> "Uri Dimant" <urid@iscar.co.il> wrote in message
>>> news:%23x8xo3jAHHA.204@TK2MSFTNGP04.phx.gbl...
>>>> William
>>>>
>>>> Can you elaborate a little bit? What are yopu trying to achive?
>>>>
>>>> "William Cheung" <chun_hei@msn.com> wrote in message
>>>> news:Ox1xeyjAHHA.3396@TK2MSFTNGP02.phx.gbl...
>>>>> Dear All,
>>>>>
>>>>> does sql2005(std.) have any tools for backup whole database to file
>>>>> for other Backup software backup?
>>>>>
>>>>> thx,
>>>>> William
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>