Can two SQL server clusters have mirrored data or near real-time?

We currently have a w2003 SQL cluster and would like to add a second cluster
to the infrastructure. Their plan is to have one online serving customers so
the other cluster may have the db restored... Is there a way to get the
databases on both clusters mirrored? We have the cluster to provide HA, I may
need a big hammer to protect the data from developers fingers!
Any suggestions?
Thanks,
Rodney
Rodney,
You might consider log shipping. Here is an article from SQL Server
magazine by Ron Talmage that you might find interesting.
http://tinyurl.com/46h45
Also, transactional replication is used by some to keep another server
refreshed for queries, reporting, etc.
Narayan Kondreddi has a replication FAQ at
http://vyaskn.tripod.com/repl_ques.htm
Russell Fields
"Rodney" <Rodney@.discussions.microsoft.com> wrote in message
news:8A87A93D-889F-477A-9209-C3D5E1EE32F7@.microsoft.com...
> We currently have a w2003 SQL cluster and would like to add a second
cluster
> to the infrastructure. Their plan is to have one online serving customers
so
> the other cluster may have the db restored... Is there a way to get the
> databases on both clusters mirrored? We have the cluster to provide HA, I
may
> need a big hammer to protect the data from developers fingers!
> Any suggestions?
> Thanks,
> Rodney

can not start sql agent

SQL Book Online lists command sqlagent.exe can start SQL
agent.
I tried to start sql agent by using sqlagent.exe from
command prompt. But get error:
"You must start SQLServerAgent as a service (using the SQL
Server Service Manager)"
Does Book Online give wrong option?
Thanks for suggestions.
-TomHi,
You can use either Control panel -- Administrative tools -- Services --
there you can select and start "SQL Agent" service.
Otherwise from command prompt you can issue below command to start the sql
agent service.
net start sqlagent
Note:
The above service name will be SQLagent$instance_name if your sql server is
a named instance.
Thanks
Hari
MCDBA
"Tom Torain" <TST_MC@.hotmail.com> wrote in message
news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
> SQL Book Online lists command sqlagent.exe can start SQL
> agent.
> I tried to start sql agent by using sqlagent.exe from
> command prompt. But get error:
> "You must start SQLServerAgent as a service (using the SQL
> Server Service Manager)"
> Does Book Online give wrong option?
> Thanks for suggestions.
> -Tom
>|||Hari,
Thanks so much. It works!
-Tom
>--Original Message--
>Hi,
>You can use either Control panel -- Administrative
tools -- Services --
>there you can select and start "SQL Agent" service.
>Otherwise from command prompt you can issue below command
to start the sql
>agent service.
>net start sqlagent
>Note:
>The above service name will be SQLagent$instance_name if
your sql server is
>a named instance.
>Thanks
>Hari
>MCDBA
>
>"Tom Torain" <TST_MC@.hotmail.com> wrote in message
>news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
>> SQL Book Online lists command sqlagent.exe can start SQL
>> agent.
>> I tried to start sql agent by using sqlagent.exe from
>> command prompt. But get error:
>> "You must start SQLServerAgent as a service (using the
SQL
>> Server Service Manager)"
>> Does Book Online give wrong option?
>> Thanks for suggestions.
>> -Tom
>
>.
>

can not start sql agent

SQL Book Online lists command sqlagent.exe can start SQL
agent.
I tried to start sql agent by using sqlagent.exe from
command prompt. But get error:
"You must start SQLServerAgent as a service (using the SQL
Server Service Manager)"
Does Book Online give wrong option?
Thanks for suggestions.
-TomHi,
You can use either Control panel -- Administrative tools -- Services --
there you can select and start "SQL Agent" service.
Otherwise from command prompt you can issue below command to start the sql
agent service.
net start sqlagent
Note:
The above service name will be SQLagent$instance_name if your sql server is
a named instance.
Thanks
Hari
MCDBA
"Tom Torain" <TST_MC@.hotmail.com> wrote in message
news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...

quote:

---

> SQL Book Online lists command sqlagent.exe can start SQL
> agent.
> I tried to start sql agent by using sqlagent.exe from
> command prompt. But get error:
> "You must start SQLServerAgent as a service (using the SQL
> Server Service Manager)"
> Does Book Online give wrong option?
> Thanks for suggestions.
> -Tom
>

---

|||Hari,
Thanks so much. It works!
-Tom

quote:

---

>--Original Message--
>Hi,
>You can use either Control panel -- Administrative

---

tools -- Services --

quote:

---

>there you can select and start "SQL Agent" service.
>Otherwise from command prompt you can issue below command

---

to start the sql

quote:

---

>agent service.
>net start sqlagent
>Note:
>The above service name will be SQLagent$instance_name if

---

your sql server is

quote:

---

>a named instance.
>Thanks
>Hari
>MCDBA
>
>"Tom Torain" <TST_MC@.hotmail.com> wrote in message
>news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
SQL[QUOTE]
>
>.
>

---