Environment details: You should have SQL Server 2019 instance.Will explore the xp_cmdshell procedure along with the new functions in SQL Server 2019 to copy or remove the files. SQL Server 2019 introduced many new stored procedures, functions, dynamic management views(DMV). The SSIS package for the file transfer, but it also requires you to build a package with the relevant tasks. You need a sysadmin role or proxy account configured to use this extended procedure. Xp_cmdshell extended stored procedure to execute commands directly in the Windows command Or copying backup files to a specific directory after a particular time. A use case of these tasks might be removing the old backup files Like copying, moving, deleting files and folders. Sometimes database professionals need to perform specific tasks at the operating system level.
0 Comments
Leave a Reply. |