Re: How to configure Log shipping on SQL server 2000 developer edi

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Rajendra (Rajendra_at_discussions.microsoft.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 03:11:04 -0700

Hi,

I am getting problem in executing the following commands. There is some
syntax error. Please guide me.

Exec bcp 'master..syslogins' out 'C:\diaGuardLogship\syslogins.dat' -N -S
'M4' -U 'sa' -P 'admin'

Exec DTSRun /S'M4'/U'sa'/P'admin'/N'Transfer Login'/M'admin'

With regards

"Rajendra" wrote:

> Hi Paul,
>
> I have now successfully configure Log shipping on developer edition. Thanx
> for the support. I have one problem. How can I change the role of primary
> server? I am trying to execute the following stored procedures but I am
> getting some error on executing the stored procedure on the secondary server.
> Can you give me direction?
> The sequence of execution is as follows:
>
> On primary server:
>
> Exec msdb..sp_change_primary_role
> @db_name = 'Test',
> @backup_log = 1,
> @terminate = 0,
> @final_state = 3,
> @access_level = 1
>
> On secondary server:
>
> msdb..sp_change_secondary_role
> @db_name ='Test',
> @do_load = 1,
> @final_state = 1,
> @access_level = 3
>
>
> But it gives error
>
> Server: Msg 22029, Level 16, State 1, Line 0
> sqlmaint.exe failed.
>
> If the above gets executed then I will execute following on monitor server:
>
> exec msdb..sp_change_monitor_role
> @primary_server ='M1',
> @secondary_server ='M2',
> @database ='Test',
> @new_source ='\\M2\TestLog'
>
> Please help me.
>
> With regards,
>
>
> "Paul Ibison" wrote:
>
> > AFAIK it is installed with Enterprise, Developer and
> > Enterprise Evaluation Editions - I can see the options on
> > my desktop, which only has Developer Edition.
> > Rgds,
> > Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
> >
> > (recommended sql server 2000 replication book:
> > http://www.nwsu.com/0974973602p.html)
> >
> >

Relevant Pages

  • Re: Joins and Scability
    ... > We have a client server application where a lot of business logic is ... > executed in stored procedures in SQL Server. ... better news is that executing business logic in SQL is generally much faster ...
    (microsoft.public.sqlserver.programming)
  • Re: Debug privileges
    ... application in the server. ... If a process executing in the workstation can use ... So is it necessary for the protected application to ensure that workstations ... Except if the person starting a process is an employee and the actual ...
    (microsoft.public.platformsdk.security)
  • Re: VB6 Exe Failing on Windows Server 2003
    ... initial failure it appears that they are not even executing at all when you ... try to run them (either from Scheduled Tasks or manually from a DOS prompt). ... same server sending SMTP emails out with no problems. ... The exes will run with no problems ...
    (microsoft.public.vb.general.discussion)
  • RE: Cannot launch application through terminal services
    ... >> I think the program is raising an error when executing outside the console. ... >> console session. ... >> desktop client) to connect to the server. ... you can contact to the software vendor support. ...
    (microsoft.public.windows.terminal_services)
  • Re: Batchupdate fails - no error
    ... actually being executing on the server? ... Vyas, MVP (SQL Server) ... > Public Sub UpdateRS ... RS.CursorLocation = adUseClient ...
    (microsoft.public.sqlserver.programming)