Agent. When you turn on SQL Server service with the trace flag the agent
does not turn on. And you cannot turn it on as a service. Here is the way
That starts the SQL agent, which is necessary for log shipping. Works great.
"Yunwen Bai" wrote:
> I guess the issue here is about restarting the sqlserveragent. please try as
> Michael stated ( to make sure sql server is up and running ) and make sure
> the creadential for the sqlagent service is correct. if you still have
> problems with starting the sqlserveragent. please let us know.
>
> Sql2005 BOL has the details about confiuring mirroring and logshiping side
> by side. you can refer BOL to set it up.
>
> Thanks
> Yunwen
>
>
> "Michael Hotek" wrote:
>
> > You have me completey confused. There is no way this should be failing.
> >
> > Yes, SQL Server Agent requires the SQL Server to be running. Why? SQL
> > Server Agent uses the msdb database which is only available when the SQL
> > Server is running.
> >
> > So, enable trace flag 1400 and start the SQL Server instance. Once the SQL
> > Server is running, start SQL Server Agent.
> >
> > --
> > Mike
> > Mentor
> > Solid Quality Learning
> >
http://www.solidqualitylearning.com > >
> >
> > "Jay Becker" <Jay Becker@discussions.microsoft.com> wrote in message
> > news:A959430F-38BC-48B3-97CE-0C1912A7A05B@microsoft.com...
> > > Hello everyone. We are evaluating SQL 2005 Standard for both a mirroring
> > > and
> > > log shipping scenario. We want to have database mirroring setup in house
> > > and
> > > log shipping to a remote site. We have successfully implemented db
> > > mirroring
> > > using the trace flag 1400, like this.....
> > >
> > > sqlservr -d"c:\program files\microsoft sql
> > > server\mssql.1\mssql\data\master.mdf" -T1400
> > >
> > > and it works great. Only problem is you must stop the default sql server
> > > service, which also stops the sql server agent. So, now the problem is
> > > that
> > > while we are using that trace flag 1400 for mirroring, we can't implement
> > > log
> > > shipping as the sql server agent must be running.
> > >
> > > I tried starting the sql server agent from command line using NET START
> > > SQLSERVERAGENT, but since the service won't start, this obviously won't
> > > either. Also, just using regular command line will not work. It says it
> > > can't be started from command line.
> > >
> > > Any suggestions or ideas as to how I can test both mirroring and log
> > > shipping at the same time?
> > >
> > > Thanks for your time.
> > >
> > > Jay
> >
> >
