Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: read only db

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… Continue reading Readonly database restoration failed

Published April 19, 2012
Categorized as DBA Tagged filegroup, read only db, read only filegroup, restore, restore database

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

Published April 13, 2011
Categorized as DBA Tagged corruption, dbcc checkdb, read only db

Recent Posts

  • CSSUG February 2020 Meet
  • CSSUG January 2020 Meet
  • CSSUG November 2019 Meet
  • CSSUG October 2019 Meet
  • Dropping a Subscriber from AG Publisher
SQL-Articles
Proudly powered by WordPress.