SQL server auto backup (but to script not to .bak) RSS

• • Reply
  fatihbarut

  Member

  92 Points

  534 Posts

  SQL server auto backup (but to script not to .bak)

  Mar 11, 2019 09:09 PM|fatihbarut|LINK

  Hi all,

  As far as I see SQL backups take lots of space however script backups take only 1/10 of it.

  Therefore I want to use generated script as a backup source.

  Is there any utility that you know I can use it to have generated script backups of my db by schedule?

  (daily or something like that)

  btw I can also write a program which uses console codes to do this (if there are any console codes)

• • Reply
  Yohann Lu

  Star

  11464 Points

  2439 Posts

  Re: SQL server auto backup (but to script not to .bak)

  Mar 12, 2019 08:40 AM|Yohann Lu|LINK

  
  Hi fatihbarut,

  fatihbarut

  As far as I see SQL backups take lots of space however script backups take only 1/10 of it.

  Therefore I want to use generated script as a backup source.

  Is there any utility that you know I can use it to have generated script backups of my db by schedule?

  (daily or something like that)

  btw I can also write a program which uses console codes to do this (if there are any console codes)

  You can use SQL Server Management Studio to backup the databases or even use Maintenance Plans, and using T-SQL is a much simpler and faster approach.

  For more detailed and refer the different ways.

  How to automate SQL Server database backups:
  https://sqlbackupandftp.com/blog/how-to-automate-sql-server-database-backups

  Simple script to backup all SQL Server databases
  https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/

  
  Best Regards

  Yong Lu

  .NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.