01. SQL DBA Industrial Base SQL Server Migration in Hindi #ibharatsoftware

01. SQL DBA Industrial Base SQL Server Migration in Hindi #ibharatsoftware

For Online Class Connect @ 99100 23813
Migration Analysis Steps:
1. Analyze the disk space of the target server for the new database, if the disk space is not enough add more space on the target server
2. Confirm the data and log file location for the target server
3. Collect the information about the Database properties (Auto Stats, DB Owner, Recovery Model, Compatibility level, Trustworthy)
4. Collect the information of dependent applications, make sure application services will be stopped during the database migration
5. Collect the information of database logins, users and their permissions. (Optional)
6. Check the database for the Orphan users
7. Check the SQL Server for any dependent objects (SQL Agent Jobs and Linked Servers)
#interview #youtube #video #tutorial #clouds #sqldba #sqlserver #sql #sqldeveloper #sqldatabase #database #datascience #backtoschool #dataanalytics #viral #mysql #informationtechnology #jobs #explore #trending #replication #registration #hindi #sqldba #sqldeveloper #dataengineering

Видео 01. SQL DBA Industrial Base SQL Server Migration in Hindi #ibharatsoftware канала IBharat Software