question

Sai-0641 avatar image
0 Votes"
Sai-0641 asked Yufeishao-msft commented

Copy only full backup script for all databases in SQL server 2014 standard

Need help to create copy only full backup automation script for all databases in sql server 2014 standard.

sql-server-general
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


what do you mean by "full backup automation script"? Do you mean script that create SQL Server Agent jobs?


0 Votes 0 ·

Yes.

1 Vote 1 ·

If the reply was helpful please mark as accepted answer so it can be helpful for other community members with same questions.

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

The normal thing would be to use Ola Hallengren's maintenance solution:
http://ola.hallengren.com.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yufeishao-msft avatar image
0 Votes"
Yufeishao-msft answered Yufeishao-msft edited

Hi @Sai-0641,

you can generate Transact-SQL (T-SQL) scripts with SSMS,
https://docs.microsoft.com/en-us/sql/ssms/tutorials/scripting-ssms?view=sql-server-ver15

or you can create a maintenance plan, a job is automatically created in SQL Server Agent under Jobs. You can use the maintenance plan to make a COPY_ONLY backup.


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.