Adding users to log-shipped DB

Hallo!
After I configure log shipping between databases on primary server A and
secondary server B, is it possible to add new users or groups and give them
access to log-shipped DB on server B only? Since the DB on server B would be
in read-only mode I'm not sure if that would allow me to add users to that
DB.
I would like a group of users to have read access to log shipped DB on
server B so they can run reports,
but they should not have any access to that DB on server A.
Thanks
TomYou can make NO changes on Server B or it will break the log shipping..After
having thought about this for a few minutes, I don;t think you can do what
you wish... You must add the users to server A, that will get shipped to
server B. If you delete the users or change permissions on Server A, that
will also go to Server B...
It is a great problem to think about, and it seems that you shouldn't be
stuck, but I think you may be... ( Maybe Ron Talmage is watching and will
have a suggestion... He is very good at log shipping.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom" <mcseman2002@.hotmail.com> wrote in message
news:%23xEFcUQxEHA.2316@.TK2MSFTNGP15.phx.gbl...
> Hallo!
> After I configure log shipping between databases on primary server A and
> secondary server B, is it possible to add new users or groups and give
them
> access to log-shipped DB on server B only? Since the DB on server B would
be
> in read-only mode I'm not sure if that would allow me to add users to that
> DB.
> I would like a group of users to have read access to log shipped DB on
> server B so they can run reports,
> but they should not have any access to that DB on server A.
> Thanks
> Tom
>

adding secondary database file

Question: When you add secondary files to an already
existing database does SQL automatically stripe existing
data across the new files or only when new data is created?I believe only if you add new data, or do things like rebuild a clustered
index (assuming both files, and the table, are in the same filegroup).
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"John Gossett" <jgossett@.nwedge.com> wrote in message
news:008e01c3c666$b3fbe6e0$a601280a@.phx.gbl...
> Question: When you add secondary files to an already
> existing database does SQL automatically stripe existing
> data across the new files or only when new data is created?|||SQL uses a process called proportional fill. It tries to keep each of the
data file the same percentage full. It does this by writing all new data to
the new file until it is as full as the existing data file..
It does NOT re-balance the existing data. You must do this by drop/re-create
the clustered index or export/import the data..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Gossett" <jgossett@.nwedge.com> wrote in message
news:008e01c3c666$b3fbe6e0$a601280a@.phx.gbl...
> Question: When you add secondary files to an already
> existing database does SQL automatically stripe existing
> data across the new files or only when new data is created?