Categories
DBA

Readonly database restoration failed

In one of my project I was working on SQL Server 2000 to SQL Server 2008 upgradation. It’s a side by side upgrade so I need to restore the database from SQL Server 2000 to SQL Server 2008, in which some of the databases are readonly. I know I will be able to restore readonly database however in this case when I tried to restore the database in SQL Server 2008 I got the error below

Categories
DBA

DBCC CHECKDB & READ ONLY DATABASES

DBCC CHECKDB & READ ONLY DATABASES:

Can you run a checkdb command on Read-only databases? If yes, does this get logged into boot page of the database? If checkdb finds an error can it fix on a read-only database?

These were some of the questions running through my mind as I manage some read-only databases in an SQL server which is mostly used for archiving and wanted to have the same level of checks and monitoring stuff we do an read write OLTP databases.