Thanks for so clear and deep explanation. Do you have video, how to restore PROD db to another, test sql server, DEV db, but with using DIFF backup? I need it so much at my work and would appreciate such video. ;)
Hii In evey production have maintenance schedule full,diff,tran backup. For refresh activity we should to take copy only backup and u r not mentioned your activity. If i am wrong please correct me.
Hi. Thanks for sharing. I noticed an error in the step where you are supposed to fix the orphan users. The query should be: EXEC sp_change_users_login 'AUTO_FIX', 'UserName', NULL, 'UserSID' instead of: sp_change_users_login AUTO_FIX, ‘UserName’, NULL, ‘Password’ Cheers
Remarkable! It's clearer to me now. A lot of unanswered question had just been answered by you. Regards.
Hi. Thanks for sharing. Excellent Explanation dude. Please keep on doing this type of videos.
Man Where are you?
why you not uploading videos?
It Was very helpful information. I would request to add more videos on DBA tutorial.
excellent....explanation..please do more vedios..
Thanks, it really helped me :) could you please provide the scripts as well. Also please create more vedios on day to day SQL DBA activities..
Thanks for so clear and deep explanation. Do you have video, how to restore PROD db to another, test sql server, DEV db, but with using DIFF backup? I need it so much at my work and would appreciate such video. ;)
Hii
In evey production have maintenance schedule full,diff,tran backup. For refresh activity we should to take copy only backup and u r not mentioned your activity.
If i am wrong please correct me.
Great explanation
thank u bro its really helpfull discussion
Only 2 vedios from ur channel?😢
backup from dev should be with copy only option so the tlog chain is not brokeb
please upload videos on daily activities of DBA
Thanks! It helped a lot :)
Gr8
Hi. Thanks for sharing. I noticed an error in the step where you are supposed to fix the orphan users. The query should be:
EXEC sp_change_users_login 'AUTO_FIX', 'UserName', NULL, 'UserSID'
instead of:
sp_change_users_login AUTO_FIX, ‘UserName’, NULL, ‘Password’
Cheers
please upload more videos on sql dba
Can upload day to day activities
Please provide me Scripts in PDF form
Please make videoss on sql
Yes