January 12, 2011 at 12:19 am
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
January 12, 2011 at 12:31 am
kasaranenikiran-725528 (1/12/2011)
How do I check if the DB is OFFLINE ??
run the below command
select name , database_id , state_desc from sys.databases
it will list out all the databases with database_id and there state .
yes, as you mentioned you are able to use your database it simply means that it is not offline.
you can try refreshing the database object from your object explorer.
January 12, 2011 at 12:44 am
I check the command,,, It shows uo as ONLINE. ANd I did the resfresh as you said. It still doesn't show up .
DOes it belong to the Replication ??? If so, does it not show up in the Instance ?
Regards
Kay
January 12, 2011 at 1:01 am
kasaranenikiran-725528 (1/12/2011)
DOes it belong to the Replication ???
No, i don;t think it has anything to do with replication. Replication does not hide the database.
It is realy strange because unless you detach a database it should be there in the database list Except for Resource database in sql server 2005 onwards because it is a hidden database.
i haven't seen such a situation.
you can trying opening a new session with management studio .
January 12, 2011 at 3:26 am
No luck ,,, even if I open a new window.
I think this is the Database created when a distributor is configuired in Replication. But ,, Not sure if it's hidden ?? Never configuired Replication .
Regards
Kay
January 12, 2011 at 3:31 am
is this a user database ?
Did you created that database?
Can you provide me its name if it is not created by you .
This is the list of all the posssible System database you can have.
1. Master.
2. MSDB
3. Model
4. tempdb
5. Distribution
6. MSsqlResource (Hidden , new in sql server 2005 onwards)
January 12, 2011 at 5:08 am
Its Distribution Database..I am looking for
I didn't know it was a system database .....
Just wanted to check,,,,, can we back up this DB ?? is it necessary ??
ANyways ,, Thanks for the help
regards
Kay
January 12, 2011 at 5:24 am
Distribution is used in replication.
http://msdn.microsoft.com/en-us/library/ms183524.aspx
'Only he who wanders finds new paths'
January 12, 2011 at 6:43 am
can you check if the auto_close_on ( db options) is enabled?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
January 12, 2011 at 8:12 am
I have configured replication before and havent come across an partially invisible database!
It doesnt sound totally right to me, but it isnt permissions is it? I wonder if you can USE DISTRIBUTION from a query window or something??
'Only he who wanders finds new paths'
January 12, 2011 at 8:13 pm
SKYBVI (1/12/2011)
can you check if the auto_close_on ( db options) is enabled?
It has nothing to do with auto_close database option.
david.alcock (1/12/2011)
I wonder if you can USE DISTRIBUTION from a query window or something??
Yes, ofcourse we can use distribution database in the query window. using use command.
Distibution database is like an other system database which can be queried easily based on your requirement.
You are right that this database is used for replication, This database is automatically created on the distributor server when you configure the distributor as a part of replication configuration process.
January 13, 2011 at 1:20 am
Thanks for all the Info Sachnam
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply