SQL Server Performance

Database doesn't show in the Instance list

Discussion in 'SQL Server 2005 General DBA Questions' started by kasaranenikiran, Jan 11, 2011.

  1. kasaranenikiran New Member

    Hi,
    I queried select * from sysdatabases and got list of 30 databases.
    But I have 29 databases in the instance (GUI) .
    Why doesn't the DB show up in the snstance ?? How do I check if the DB is OFFLINE ??
    I used the
    use DBName
    go
    and it was successful. SO, I don't think its offline ... right ??
    Suggestions....please

    Regards
    Kay
    kasaranenikiran, Jan 11, 2011
    #2

  2. satya Moderator

    When you open up the SQL Server Management Studio on the object explorer details what do you see on right-hand side.
    Again under SSMS database pane do you see any database showing offline/restriced user?
    Check SQL error log for any informaton.
    satya, Jan 12, 2011
    #3

  3. kasaranenikiran New Member

    It is the "Distribution" database I was looking for.... I didn't know it comes under system databases ..
    Is it necessary to backup this database ??
    regards
    Kay
    kasaranenikiran, Jan 12, 2011
    #4

  4. satya Moderator

    Yes you must backup the replication related databases, For more information, Microsoft has an MSDN article that goes through the entire Backup and Recovery strategy for databases involved in replication. There is quite a bit more work here than you may initially think, so be prepared.
    http://msdn.microsoft.com/en-us/library/ms151152.aspx
    satya, Jan 13, 2011
    #5

Share This Page