|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
backup againDear 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? Show quote "William Cheung" <chun_***@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 Show quote "Uri Dimant" <u***@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_***@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 Show quote "William Cheung" <chun_***@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" <u***@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_***@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 Show quote "Uri Dimant" <u***@iscar.co.il> wrote in message news:%23SGqKKkAHHA.4808@TK2MSFTNGP03.phx.gbl... > Hi > > > See ,BACKUP DATABASE command in the BOL > > > > > "William Cheung" <chun_***@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" <u***@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_***@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 ServerShow quote "William Cheung" <chun_***@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" <u***@iscar.co.il> wrote in message > news:%23SGqKKkAHHA.4808@TK2MSFTNGP03.phx.gbl... >> Hi >> >> >> See ,BACKUP DATABASE command in the BOL >> >> >> >> >> "William Cheung" <chun_***@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" <u***@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_***@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/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx http://www.databasejournal.com/features/mssql/article.php/3389831 vinu Show quote "William Cheung" <chun_***@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" <u***@iscar.co.il> wrote in message > news:%23SGqKKkAHHA.4808@TK2MSFTNGP03.phx.gbl... >> Hi >> >> >> See ,BACKUP DATABASE command in the BOL >> >> >> >> >> "William Cheung" <chun_***@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" <u***@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_***@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. -- Show quoteArnie 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_***@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 > 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_***@msn.com> wrote: Show quote >Dear All, > >does sql2005(std.) have any tools for backup whole database to file for >other Backup software backup? > >thx, >William >  |
|||||||||||||||||||||||
Other interesting topics