Add users to logshipping database on secondary server

Hi Folks,
I need to add new read only users to our databases on seconday server of
logshipping.
As all those db's are readonly, How can I add users to it?
It is on sql 2000 sp3
Please help.
Kumar> As all those db's are readonly, How can I add users to it?
You can't. You can't do anything inside a log shipped or mirror database. So this has to be
performed in the source database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:61086CE0-9F44-495B-AEBC-F8D8E9BBCD48@.microsoft.com...
> Hi Folks,
> I need to add new read only users to our databases on seconday server of
> logshipping.
> As all those db's are readonly, How can I add users to it?
> It is on sql 2000 sp3
> Please help.
> Kumar

Add users to logshipping database on secondary server

Hi Folks,
I need to add new read only users to our databases on seconday server of
logshipping.
As all those db's are readonly, How can I add users to it?
It is on sql 2000 sp3
Please help.
Kumar
> As all those db's are readonly, How can I add users to it?
You can't. You can't do anything inside a log shipped or mirror database. So this has to be
performed in the source database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:61086CE0-9F44-495B-AEBC-F8D8E9BBCD48@.microsoft.com...
> Hi Folks,
> I need to add new read only users to our databases on seconday server of
> logshipping.
> As all those db's are readonly, How can I add users to it?
> It is on sql 2000 sp3
> Please help.
> Kumar

Add users to logshipping database on secondary server

Hi Folks,
I need to add new read only users to our databases on seconday server of
logshipping.
As all those db's are readonly, How can I add users to it?
It is on sql 2000 sp3
Please help.
Kumar> As all those db's are readonly, How can I add users to it?
You can't. You can't do anything inside a log shipped or mirror database. So
this has to be
performed in the source database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:61086CE0-9F44-495B-AEBC-F8D8E9BBCD48@.microsoft.com...
> Hi Folks,
> I need to add new read only users to our databases on seconday server of
> logshipping.
> As all those db's are readonly, How can I add users to it?
> It is on sql 2000 sp3
> Please help.
> Kumar

Add Datafile

I have a need to add a secondary datafile. My question pertains to the
FIlegroups tab in Enterprise Manager. Do I need to change the value of the
Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
database can only have one primary file.
Hi
I prefer to do such things by QA not by EM
CREATE DATABASE databasename
GO
ALTER DATABASE databasename SET RECOVERY FULL
ALTER DATABASE databasename ADD FILEGROUP new_customers
ALTER DATABASE databasename ADD FILEGROUP sales
GO
ALTER DATABASE databasenameADD FILE
(NAME=databasename_data_1',
FILENAME='d:\mw.dat1')
TO FILEGROUP new_customers
ALTER DATABASE databasename
ADD FILE
(NAME='databasename_data_2',
FILENAME='d:\mw.dat2')
TO FILEGROUP sales
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:560E20AD-0955-44A6-95AF-6C853151F478@.microsoft.com...
>I have a need to add a secondary datafile. My question pertains to the
> FIlegroups tab in Enterprise Manager. Do I need to change the value of
> the
> Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
> database can only have one primary file.

Add Datafile

I have a need to add a secondary datafile. My question pertains to the
FIlegroups tab in Enterprise Manager. Do I need to change the value of the
Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
database can only have one primary file.Hi
I prefer to do such things by QA not by EM
CREATE DATABASE databasename
GO
ALTER DATABASE databasename SET RECOVERY FULL
ALTER DATABASE databasename ADD FILEGROUP new_customers
ALTER DATABASE databasename ADD FILEGROUP sales
GO
ALTER DATABASE databasenameADD FILE
(NAME=databasename_data_1',
FILENAME='d:\mw.dat1')
TO FILEGROUP new_customers
ALTER DATABASE databasename
ADD FILE
(NAME='databasename_data_2',
FILENAME='d:\mw.dat2')
TO FILEGROUP sales
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:560E20AD-0955-44A6-95AF-6C853151F478@.microsoft.com...
>I have a need to add a secondary datafile. My question pertains to the
> FIlegroups tab in Enterprise Manager. Do I need to change the value of
> the
> Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
> database can only have one primary file.

Add Datafile

I have a need to add a secondary datafile. My question pertains to the
FIlegroups tab in Enterprise Manager. Do I need to change the value of the
Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
database can only have one primary file.Hi
I prefer to do such things by QA not by EM
CREATE DATABASE databasename
GO
ALTER DATABASE databasename SET RECOVERY FULL
ALTER DATABASE databasename ADD FILEGROUP new_customers
ALTER DATABASE databasename ADD FILEGROUP sales
GO
ALTER DATABASE databasenameADD FILE
(NAME=databasename_data_1',
FILENAME='d:\mw.dat1')
TO FILEGROUP new_customers
ALTER DATABASE databasename
ADD FILE
(NAME='databasename_data_2',
FILENAME='d:\mw.dat2')
TO FILEGROUP sales
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:560E20AD-0955-44A6-95AF-6C853151F478@.microsoft.com...
>I have a need to add a secondary datafile. My question pertains to the
> FIlegroups tab in Enterprise Manager. Do I need to change the value of
> the
> Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
> database can only have one primary file.