I enjoyed watching this video. Host explains the Availability Group and Backup Options. in detail by listing each type. I recommend this to others especially for DBAs Thanks for educating the community and appreciate all your efforts in educating others. Please keep producing some more videos. Thanks a bunch
i had some issues doing this, maybe i missed something but i tried following the example on SQL 2014. where the full backup runs successful. but when using T-SQL the file name gets hardcoded into the script, so no new files will get created. using maintenance plan instead it will create new files on every backup. and if following the T-SQL when doing transaction logs, Copy Only will not work, because its only used for Full Backups and not Tlogs. I cloud get the Tlog working, but again the file name was hardcoded, and it only worked if the backup plan was set to primary only. what solved my backup plan. was to use the Maintenance Plan Wizard and create the same job on both servers, and from here its also easier to add new databases to the job than needed to edit the script afterward
I enjoyed watching this video.
Host explains the Availability Group and Backup Options. in detail by listing each type.
I recommend this to others especially for DBAs
Thanks for educating the community and appreciate all your efforts in educating others.
Please keep producing some more videos.
Thanks a bunch
Thanks Brother you are a medicine for all of us who love to working as a DBA🙏
thanks for kind words
Thank you for taking the time to compile this Video.
You are my AI, SUPER GENIUS
Thanks:)
You are a gem 💎 thanks
Thanks Bro ..this was helpful
You're the best! thanks!
I guess I could use the decision script to run other jobs depending on where the primary replica is, right?
Thanks again!
i had some issues doing this, maybe i missed something but i tried following the example on SQL 2014. where the full backup runs successful. but when using T-SQL the file name gets hardcoded into the script, so no new files will get created. using maintenance plan instead it will create new files on every backup. and if following the T-SQL when doing transaction logs, Copy Only will not work, because its only used for Full Backups and not Tlogs. I cloud get the Tlog working, but again the file name was hardcoded, and it only worked if the backup plan was set to primary only.
what solved my backup plan. was to use the Maintenance Plan Wizard and create the same job on both servers, and from here its also easier to add new databases to the job than needed to edit the script afterward
Thank you for saving my day!!!
Glad to hear that it was helpful.
Nice video, Thanks
You are very welcome. Thanks for liking the effort.
Hi, do you know how to make it automatic using timestamp in filename?