Update PMDB.Create_Database_Backup.sql

[Imran-imtiaz48]

IMPROVEMENTS MADE

1. Error Handling with TRY...CATCH: o Added error handling to catch and display any issues during execution.
2. Improved String Handling: o Used NVARCHAR for better Unicode support. o Used sp_executesql for executing dynamic SQL, which is safer and more efficient.
3. Removed Hardcoded Paths: o Added flexibility for setting the backup folder path based on the server.
4. Enhanced Readability: o Organized and grouped related PRINT statements to make debugging easier. o Removed unnecessary debug outputs and kept only meaningful messages.
5. SQL Injection Prevention: o Avoided direct string concatenation by constructing SQL in a safer way.
6. NEXT STEPS • Standardize Backup Path: Replace the hardcoded paths with a configuration table or parameter to make it dynamic and maintainable. • Logging: Add proper logging to record the success or failure of backups in a table or file for auditing purposes. • Security: Ensure that the procedure is executed with the least privilege necessary to perform backups.