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

Sai 126 Reputation points
2021-10-13T15:06:01.707+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,706 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 101K Reputation points MVP
    2021-10-13T21:27:37.75+00:00

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

    0 comments
  2. YufeiShao-msft 7,056 Reputation points
    2021-10-14T08:55:10.173+00:00

    Hi @Sai ,

    you can generate Transact-SQL (T-SQL) scripts with SSMS,
    https://learn.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".

    0 comments