Re: Newbie question on meaning of icon...

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 01/11/05


Date: Tue, 11 Jan 2005 14:19:05 -0500

The 'sharing' hand means the database has been enabled for replication.
First, you read BOL (Books On-Line) and understand what replication is and
hw it works before you make any adjustments.

IMHO, your first concern should be backup and recovery. Next comes
space/performance management and monitoring. Last comes changes and
improvements.

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bairda" <bairda@discussions.microsoft.com> wrote in message
news:F5139783-2191-442A-9584-04C743848493@microsoft.com...
> Hi!  I have "inherited" a SQL server that I am quickly trying to get up to
> speed on administering.  There are several db's on the server.  If I look
at
> the db's in enterprise manager one of them has what looks to be a "shared"
> icon beside the db name.  It looks just like the other db icons but has
that
> "share" hand underneath.  What does this symbolize and how do I make
> adjustments to this setting.
>
> Sorry for being so obtuse!  Thanks for the help!
> -alex-


Relevant Pages

  • Re: How to Replicate an SQL Server 2000 Database
    ... If i do this in Query Analyser should i have the DB closed? ... Now regarding Replication, i am brand new to this... ... And then stop and start SQL Server. ... Director of Text Mining and Database Strategy ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication Suggestions
    ... Looking for a SQL Server replication book? ... >I have an application with a sql backend. ... > database on the webbox and an internal database for inter-company use. ...
    (microsoft.public.sqlserver.replication)
  • Replicate to MS Access via the Internet
    ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
    (microsoft.public.access.replication)
  • Replicate to MS Access via the Internet
    ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
    (microsoft.public.sqlserver.replication)
  • Re: How convert from Desktop to PDA
    ... Replication is used when you want to synchronize the SQL Server ... You may also do that with RDA, ... > How can I convert an Sql Server database on desktop into a Sql server CE ...
    (microsoft.public.sqlserver.ce)