Listing all MSSQL performed for specific database

Yesterday I’ve stuck with restoring some MSSQL database, because of incompatibility between used differential and full backups, after I’ve found correct full backup, restore process completed without any problem. The following error identifies that: The log or differential backup cannot be restored because no files are ready to rollforward The following script helped me to […]

Clustered MS SQL dependency on mounted volume

Recently I have added new mounted volume to Microsoft cluster (lets say disk 3 mounted at m:\history), and tried to restore some old backup to it. But after I have run SQL script I’ve immediately got an SQL error: Only formatted files on which the cluster resource of the server has a dependency can be […]