backup again

Dear All,
does sql2005(std.) have any tools for backup whole database to file for
other Backup software backup?
thx,
WilliamWilliam
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...
>|||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...
>|||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 help 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...
>|||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
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 , NOUNLOA
D ,
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/pr...cle.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...
>|||William,
You don't need to purchase the third party open file, SQL
agents to do SQL Server backups. They aren't used that often
and are often problematic - it's more common to just use
SQL Server native backups and backup to disk. Enterprise
backup software or tape backups can then just backup the SQL
Server backup file that you create with the SQL Server
native backup. As others have pointed out, you just use
T-SQL backup commands, you can schedule these using SQL
Server Agent.
-Sue
On Tue, 7 Nov 2006 15:16:17 +0800, "William Cheung"
<chun_hei@.msn.com> wrote:

>Dear All,
>does sql2005(std.) have any tools for backup whole database to file for
>other Backup software backup?
>thx,
>William
>