Database Restore Archives - SQLServer Performance Optimization and Automation

Msg 3415, Level 16, State 5, Line 3 Database ‘StackOverflow2010’ cannot be upgraded because it is read-only, has read-only files or the user does not have permissions to modify some of the files. Make the database or files writeable, and rerun recovery.

Error/Fix: Database cannot be upgraded because it is read-only or has read-only files

Ajay Dwivedi | July 26, 2020

Yesterday during my online SQL Server class, I was trying to attach 10 GB size version of StackOverflow database that I used previosly with another instance. When I

SQL Server – Get Database Backup History for Crash Recovery

Ajay Dwivedi | April 18, 2018

It is not easy to find out right backups for restore activity when people are watching you during database crash situation. So I have created below TSQL script

Script-SQLDatabaseRestore cmdlet in SQLDBATools Module

Ajay Dwivedi | April 14, 2018

Restoring multiple databases can be painful especially when each of them have multiple database file(s). Four years back, I wrote TSQL script that would accept database backup path,

Category: Database Restore