skip to main | skip to sidebar

Ramesh Maddileti

Welcome To Rams World

Tuesday, October 16, 2012

Steps to Access a Database which is in Inaccess mode

Steps to Remove Database Inaccess Mode

select databaseproperty('irisdb_admin','isShutdown')

alter database irisdb_admin set offline

alter database irisdb_admin set online

Posted by Ramesh at 1:23 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

My photo
Ramesh
Madanapalli, Andhra Pradesh, India
Nothing Special....
View my complete profile

Blog Archive

  • ►  2021 (1)
    • ►  Feb (1)
  • ►  2020 (3)
    • ►  Mar (2)
    • ►  Feb (1)
  • ►  2016 (2)
    • ►  Jul (1)
    • ►  Jun (1)
  • ►  2014 (3)
    • ►  May (3)
  • ►  2013 (4)
    • ►  Nov (3)
    • ►  Jan (1)
  • ▼  2012 (5)
    • ▼  Oct (3)
      • SQL Server Joins......
      • Steps to Access a Database which is in Inaccess mode
      • Find table being locked in SQL Server 2008/2005
    • ►  Mar (1)
    • ►  Jan (1)
  • ►  2011 (2)
    • ►  Feb (2)
  • ►  2010 (5)
    • ►  May (1)
    • ►  Feb (4)

Sql Server

  • Deploying and Administering Reporting Services
  • MDX Tutorial
  • Microsoft SQL Server Tutorials
  • SQL INSERT INTO - SQL Tutorial
  • SQL Server - Blogs
  • SQL Server 2005 reporting services
  • SQL Server 2008 Tutorial
  • SQL Server How-to Videos
  • SQL Server Training
  • SSAS overview
  • SSIS overview
  • SSIS SSAS SSRS Tutorials
  • SSRS overview