Understood
- When I understood Basic Architecture I can proceed to learn Recovery Models.
- When I understood SQL Authentication I can proceed to learn Windows Authentication.
- When I understood Filegroup I can Proceed to learn Table Partitioning.
- When I understood moving Data files I can proceed to learn moving Indexes/Tables.
- When I understood default port I can proceed to learn firewall settings.
- When I understood Backup I can proceed to learn Stripped Backup.
- When I understood Database mail I can proceed to learn automation of notification.
- When I understood Log Backup I can proceed to learn Shrinking.
Finally,
- When I understood standard Edition, I can proceed to learn Enterprise Edition.
Note:- When we keep on learning, it's called study.
🙏🌹Happy Forwarding🌹🙏
Best Regards
Amit Vaid
Bring Database online from restoring state
ReplyDeletehttps://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-and-recovery-overview-sql-server?view=sql-server-ver16
Recovery and the transaction log
For most restore scenarios, it is necessary to apply a transaction log backup and allow the SQL Server Database Engine to run the recovery process for the database to be brought online.