Database Refresh Automation in MS SQL SERVER

Рет қаралды 4,195

11 ай бұрын

Join this channel to get access to perks:
/ @mssqldbatechsupport
Join the whats app Group for the scripts and assistance:
chat.whatsapp.com/LBDdY1UA0Sn...
You Can Also Download the scripts from below folder
drive.google.com/drive/folder...
We strongly believe there is always chance of betterment, so suggestions are most welcome.
Happy learning, and best of luck in your professional journey!
The journey of improvement is ongoing and never be an end.
Thank you!
MS SQL DBA Tech Support

Пікірлер: 20

@user-sg1eu7og5i 8 ай бұрын

Thanks Harsh for doing such a good database refresh automation.

@MSSQLDBATechSupport 8 ай бұрын

Hello sivaraja Pacha Thank you for your kind words. I'm glad to hear that the database refresh automation was successful and met your expectations. It's always a pleasure to contribute to the DBAs community. Thanks & Regards: MS SQL DBA TECH SUPPORT mssqldbatechteam@gmail.com

@user-vn1rc3ri9s 11 ай бұрын

Thanks man. Useful implementation.

@MSSQLDBATechSupport 11 ай бұрын

You're welcome!

@ssv91952 11 ай бұрын

Thanks for doing such a good automation, Really appreciate especially regarding automatic migrate of user and permission of destination database. Again thanks for sharing such nice demo. 👋👌

@MSSQLDBATechSupport 11 ай бұрын

Thank you for expressing your gratitude! I'm delighted to hear that you find the automation and the demo for user and permission migration to a destination database helpful. Knowing that my assistance has been beneficial to you is truly rewarding. Thanks & Regards *MS SQL DBA TECH SUPPPORT*

@aniruddhabera6049 7 ай бұрын

Thanks for the automation on refresh activity

@MSSQLDBATechSupport 7 ай бұрын

Always welcome

@tiruvidulamallikarjun2604 11 ай бұрын

Very helpful this on real time

@MSSQLDBATechSupport 11 ай бұрын

Glad to hear that!

@sqkumar7198 5 ай бұрын

Hi Thanks for the video, how did you fix step 5, can you post a script that will use to restore the latest file (dynamically named backup file) from backup?

@MSSQLDBATechSupport 5 ай бұрын

Hello Kumar, After long time i watched my video what would be there in 5 step. i am not using the restore the last file dynamically. Since i am aimed to automate for particular database. i am keeping the database name as static only. when request comes it is taking copy only back up and moved to destination and --->restoring the database name. To fix the issue i just changed the folder path which is i said the same in the video last.

@sqkumar7198 5 ай бұрын

@@MSSQLDBATechSupport Thanks for your prompt reply. Any plan in future to make a video with timestamped backup and restore with latest backup ? Thanks

@MSSQLDBATechSupport 5 ай бұрын

Once time permits i will do

@manendrakollepara8620 11 ай бұрын

Hi Harsha, i tried this but in sexond step i got error msg in second step for copying .can u please help me here

@MSSQLDBATechSupport 11 ай бұрын

Please provide the error details and code that your trying to use.

@SiddikAhmed-ge9wq Ай бұрын

Hi Harsha, I'm not able to access the drive. Could you pls share the script

@MSSQLDBATechSupport Ай бұрын

whenever there is change in new links or whatever... we cant change in old videos description for all videos.however u can get it new information about links in new videos description