Dear All,

does sql2005(std.) have any tools for backup whole database to file for
other Backup software backup?

thx,
William

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
>

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
>>
>
>

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
>>>
>>
>>
>
>

With SQL 2005 Standard Edition, you can create a "Maintenance Job" to backup
on schedule, or you can create a SQL Agent Job to execute a SQL Backup
command.

SQL Backup is quite robust, and you may be OK without any other software.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"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
>

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
>>>>
>>>
>>>
>>
>>
>
>

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
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Hi

you have to create backup script first and schedule it through sql job.
Schedule depends on your requirements and how much data you can afford to
lose

Here is the very basic script


full backup


BACKUP DATABASE [myDB] TO DISK=N'c:\myDBbackup.bak' WITH
NOINIT,Name='myDBbackup'

differential

BACKUP DATABASE [myDB] TO DISK=N'c:\myDBbackup.bak' WITH
NOINIT,DIFFERENTIAL,Name='myDBbackup'
log

BACKUP LOG [myDB] TO DISK = N'c:\myDBbackup.bak' WITH NOINIT , NOUNLOAD ,
NAME = 'myDBbackup', NOSKIP , STATS = 10, NOFORMAT

You need to understand how restore works... BOL is the best tool..

You will get some custom script from the following site

www.sqlservercentral.com

http://www.microsoft.com/technet/pro...ackuprest.mspx
http://www.databasejournal.com/featu...le.php/3389831

vinu




"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
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>