Hello there,
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put databas
e
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue coul
d
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
LionelThe one performing the backup is SQL Server, not Agent. So you need proper a
ccount for SQL Server
service. No, they don't need to use the same account. But watch out for the
mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, t
he
> database backup files were stored on local disk. We are think to put datab
ase
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue co
uld
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
Showing posts with label administrator. Show all posts
Showing posts with label administrator. Show all posts
Friday, February 24, 2012
About Sql agent
Hello there,
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put database
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue could
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
Lionel
The one performing the backup is SQL Server, not Agent. So you need proper account for SQL Server
service. No, they don't need to use the same account. But watch out for the mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, the
> database backup files were stored on local disk. We are think to put database
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue could
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put database
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue could
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
Lionel
The one performing the backup is SQL Server, not Agent. So you need proper account for SQL Server
service. No, they don't need to use the same account. But watch out for the mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, the
> database backup files were stored on local disk. We are think to put database
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue could
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
About Sql agent
Hello there,
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put database
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue could
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
LionelThe one performing the backup is SQL Server, not Agent. So you need proper account for SQL Server
service. No, they don't need to use the same account. But watch out for the mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, the
> database backup files were stored on local disk. We are think to put database
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue could
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put database
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue could
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
LionelThe one performing the backup is SQL Server, not Agent. So you need proper account for SQL Server
service. No, they don't need to use the same account. But watch out for the mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, the
> database backup files were stored on local disk. We are think to put database
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue could
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
Sunday, February 19, 2012
About question of Sql server 2005 cluster.
I am Sql server administrator in a company and I don't have experience of sql
server 2005 failedover cluster. Recently my company decides to use cluster to
conduct disaster recovery strategy. I want to make a preperation about it,
could somebody recommend some online document to read? In addition, I read
some doc that most of that work are conducted by system administrator, such
as network setup, MSCS, SAN and so on, what kind of work that I need to do?
e.g. sql server software installation, monistor and so on? Are those a lot of
difference? Please give me advice? Thanks in advance.
There is no substitute for training and hands-on experience. Check out
www.clusterhelp.com.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:273054A5-23D4-4200-9C6C-CDF8089DB710@.microsoft.com...
I am Sql server administrator in a company and I don't have experience of
sql
server 2005 failedover cluster. Recently my company decides to use cluster
to
conduct disaster recovery strategy. I want to make a preperation about it,
could somebody recommend some online document to read? In addition, I read
some doc that most of that work are conducted by system administrator, such
as network setup, MSCS, SAN and so on, what kind of work that I need to do?
e.g. sql server software installation, monistor and so on? Are those a lot
of
difference? Please give me advice? Thanks in advance.
|||Hi,
You can start with this document
SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Hope this helps,
Ben Nevarez
Senior Database Administrator
"Iter" wrote:
> I am Sql server administrator in a company and I don't have experience of sql
> server 2005 failedover cluster. Recently my company decides to use cluster to
> conduct disaster recovery strategy. I want to make a preperation about it,
> could somebody recommend some online document to read? In addition, I read
> some doc that most of that work are conducted by system administrator, such
> as network setup, MSCS, SAN and so on, what kind of work that I need to do?
> e.g. sql server software installation, monistor and so on? Are those a lot of
> difference? Please give me advice? Thanks in advance.
>
|||Here is a link to a TechNet webcast on using Virtual Server to build a test
and training cluster.
http://support.microsoft.com/kb/891798/en-us
Make your mistakes on the test platform so you are practiced and ready when
you need to build and support the real thing.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:273054A5-23D4-4200-9C6C-CDF8089DB710@.microsoft.com...
>I am Sql server administrator in a company and I don't have experience of
>sql
> server 2005 failedover cluster. Recently my company decides to use cluster
> to
> conduct disaster recovery strategy. I want to make a preperation about it,
> could somebody recommend some online document to read? In addition, I read
> some doc that most of that work are conducted by system administrator,
> such
> as network setup, MSCS, SAN and so on, what kind of work that I need to
> do?
> e.g. sql server software installation, monistor and so on? Are those a lot
> of
> difference? Please give me advice? Thanks in advance.
>
server 2005 failedover cluster. Recently my company decides to use cluster to
conduct disaster recovery strategy. I want to make a preperation about it,
could somebody recommend some online document to read? In addition, I read
some doc that most of that work are conducted by system administrator, such
as network setup, MSCS, SAN and so on, what kind of work that I need to do?
e.g. sql server software installation, monistor and so on? Are those a lot of
difference? Please give me advice? Thanks in advance.
There is no substitute for training and hands-on experience. Check out
www.clusterhelp.com.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:273054A5-23D4-4200-9C6C-CDF8089DB710@.microsoft.com...
I am Sql server administrator in a company and I don't have experience of
sql
server 2005 failedover cluster. Recently my company decides to use cluster
to
conduct disaster recovery strategy. I want to make a preperation about it,
could somebody recommend some online document to read? In addition, I read
some doc that most of that work are conducted by system administrator, such
as network setup, MSCS, SAN and so on, what kind of work that I need to do?
e.g. sql server software installation, monistor and so on? Are those a lot
of
difference? Please give me advice? Thanks in advance.
|||Hi,
You can start with this document
SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Hope this helps,
Ben Nevarez
Senior Database Administrator
"Iter" wrote:
> I am Sql server administrator in a company and I don't have experience of sql
> server 2005 failedover cluster. Recently my company decides to use cluster to
> conduct disaster recovery strategy. I want to make a preperation about it,
> could somebody recommend some online document to read? In addition, I read
> some doc that most of that work are conducted by system administrator, such
> as network setup, MSCS, SAN and so on, what kind of work that I need to do?
> e.g. sql server software installation, monistor and so on? Are those a lot of
> difference? Please give me advice? Thanks in advance.
>
|||Here is a link to a TechNet webcast on using Virtual Server to build a test
and training cluster.
http://support.microsoft.com/kb/891798/en-us
Make your mistakes on the test platform so you are practiced and ready when
you need to build and support the real thing.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:273054A5-23D4-4200-9C6C-CDF8089DB710@.microsoft.com...
>I am Sql server administrator in a company and I don't have experience of
>sql
> server 2005 failedover cluster. Recently my company decides to use cluster
> to
> conduct disaster recovery strategy. I want to make a preperation about it,
> could somebody recommend some online document to read? In addition, I read
> some doc that most of that work are conducted by system administrator,
> such
> as network setup, MSCS, SAN and so on, what kind of work that I need to
> do?
> e.g. sql server software installation, monistor and so on? Are those a lot
> of
> difference? Please give me advice? Thanks in advance.
>
Subscribe to:
Comments (Atom)