Database backup and restore automation

• somadattamallick

  SSC Journeyman

  Points: 94

  More actions

  April 18, 2016 at 1:58 pm

  #326572

  Hi,

  I am part of application deployment. mostly, I used to take the database backup and restore the same databse before and after the deployment.

  Could you please help me to do the Automation of the Database backup and restore task.

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  April 18, 2016 at 3:34 pm

  #1872913

  The way to automate backups is to use T-SQL (or Powershell). I cover all the basics in this article.[/url]

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• johnwalker10

  SSCrazy Eights

  Points: 9124

  More actions

  April 18, 2016 at 11:19 pm

  #1872939

  You can also take the help of this link: http://sqlbak.com/blog/automated-database-backup-and-restore-for-sql-server/