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… Continue reading Readonly database restoration failed
Tag: read only db
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… Continue reading DBCC CHECKDB & READ ONLY DATABASES