Last post Mar 12, 2019 08:40 AM by Yohann Lu
Member
90 Points
519 Posts
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)
Star
11444 Points
2439 Posts
Microsoft
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
Member
90 Points
519 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)
Star
11444 Points
2439 Posts
Microsoft
Re: SQL server auto backup (but to script not to .bak)
Mar 12, 2019 08:40 AM|Yohann Lu|LINK
Hi fatihbarut,
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
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.