How to check database restore percentage
we can use the below script to check database backup restore percentage details and many more.use master;SELECT r.session_id,r.command,CONVERT(NUMERIC(6,2),r.percent_complete) AS ,CONVERT(V...
26Feb2020
Script to take database users and respective roles backup
It is very important to take a database users and the respective privileges backup while you perform a database restore, as once the database restore complete we must replace the same access rights be...
12Feb2020
Subscribe to:
Posts (Atom)