SQL Server 2005 Automatic Backups

• manikam_sundar

  SSC Veteran

  Points: 242

  More actions

  November 16, 2009 at 10:21 pm

  #212675

  Hi Friends,

  Is it possible to perform Automatic Backups (ex: Daily at 8 pm)

  in SQL Server 2005 Standard edition.If so,Pl give me a detailed explanation about it....

  Thanks in advance

  Regards,

  Sundar

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  November 16, 2009 at 10:29 pm

  #1080031

  Hi, you've got quite a few options...

  1. Maintenance Plans

  2. Schedule a TSQL task job with relevant BACKUP.... code...

  3. Build a SSIS package with the backup tasks.

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

• Atul DBA

  Hall of Fame

  Points: 3610

  More actions

  November 17, 2009 at 7:16 am

  #1080228

  You can use the Maintenance plan for the scheduled database backup option as suggested by Henrico Bekker.

  You can read more about maintenance plan on SQL Book on Line. Some summary is here listed on below url:

  http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

• SQLQuest29

  SSCrazy Eights

  Points: 8264

  More actions

  November 18, 2009 at 10:30 am

  #1081059

  manikam_sundar (11/16/2009)

  ---

  Hi Friends,

  Is it possible to perform Automatic Backups (ex: Daily at 8 pm)

  in SQL Server 2005 Standard edition.If so,Pl give me a detailed explanation about it....

  Thanks in advance

  Regards,

  Sundar

  Hello,

  You can use SQL Agent job -> TSQL code -> schedule at 8PM.

  For TSQL code:

  Backup database [databaseName]

  to disk = '\\Servername\sharefolder\filename.bak'

  with init, stats = 10

  Hope this helps,

  \\K

  ______________________________________________________________________________________________________________________________________________________________________________________
  HTH !
  Kin
  MCTS : 2005, 2008
  Active SQL Server Community Contributor 🙂