MSSQL 2000- Backup Activity on a Network Machine

Hi,
I am using an Enterprise Manager and i have created a Database Maintainance Plan, can anybody guide me as to how to create backup on a remote machine.

I also mapped that device(say M/c B) onto my server box(M/c A) but i am not able to see that particular location in my backup activity screen.

Can this be done in the first place ?

Regards,
Tahirwe need some clarification.

do you want to backup databases on machine A to machine B or do you want to manage backups of databases that are on machine B from machine A?|||Yes i want to backup databases on machine A to machine B through Enterprize manager.|||While doing the backup on a networked remote machine which has been given full rights the job fails giving this error

BACKUP failed to complete the command BACKUP DATABASE [qa_tm_bdr_fix2] TO DISK = N'\\192.168.156.7\DBBackup\MUMSV075\qa_tm_bdr_fix2 _db_200612262300.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT|||Is your SQL Instance on A running under the system-account? The system account had no rights on B.

But there should be a more useful messge somewhere about why the job fails. Maybe in the errorlog? Have looked at the details in the jobhistory?|||Lexiflex is right. Make sure that the service account running the SQL server on B has enough permissions on the share (on A) where it should write the backup file. So in your case the account under which SQL Server B is running should have the permissions on the \\192.168.156.7\DBBackup share. I assume you allready shared the folder ... The problem Lexiflex is referring to is that the 'local system account' from machine A is not the same as the 'local system account' on machine B ... although it looks like it's the same one, it's definitely not ! You shouldn't run SQL Server under the local system account ... ever.

Been there, done that, worked fine.

Gr,
Yveau|||I am betting this is the problem as well. You will need to change the sql server and sql agent accounts to run under a domain account that has rights to your backup location.|||Thanks a lot for all ur help......it works......

Regards,
Tahir

MSDTC unable to go online

Hi,
I have a problem starting my MSDTC.
I have enable network DTC access (following the instructions in MS KB
817064) on two of my servers before I clustered them. The DTC services run
well. After that, I configured my servers in cluster Node A and B
(Active/Passive). The DTC immediately failed to start. I carried on and
configured my MSDTC resources (following the instructions in MS KB 301600) on
Node A. The other resources like IP, Physical disk, Network name able to
bring online except for DTC.
What is happening? I have tried my best to follow all instructions as
closely as possible. I seems to be struck. Still have to install SQL 2005
but now spend days to resolve the MSDTC issue. Please kindly help me!
Thanks a lot in advance!
Received error like
MS DTC was unable to start because the installation was not configured to
run on a cluster. Please create a MS DTC resource through cluster
administrator. Error Specifics:
d:\srvrtm\com\complus\dtc\shared\mtxclu\mtxclusetu phelper.cpp:534, Pid: 3192,
CmdLine: C:\WINDOWS\system32\msdtc.exe
Could not start the MS DTC Transaction Manager.
MS DTC Transaction Manager start failed. LogInit returned error 0x3.
Dear Shann Lim,
Have a look at this KB http://support.microsoft.com/kb/867520
and let us know if that solved your problem
good luck,
Edwin.
"Shann Lim" <ShannLim@.discussions.microsoft.com> wrote in message
news:36DA21D5-FF1C-47D7-82EC-585E86597416@.microsoft.com...
> Hi,
> I have a problem starting my MSDTC.
> I have enable network DTC access (following the instructions in MS KB
> 817064) on two of my servers before I clustered them. The DTC services
run
> well. After that, I configured my servers in cluster Node A and B
> (Active/Passive). The DTC immediately failed to start. I carried on and
> configured my MSDTC resources (following the instructions in MS KB 301600)
on
> Node A. The other resources like IP, Physical disk, Network name able to
> bring online except for DTC.
> What is happening? I have tried my best to follow all instructions as
> closely as possible. I seems to be struck. Still have to install SQL
2005
> but now spend days to resolve the MSDTC issue. Please kindly help me!
> Thanks a lot in advance!
> Received error like
> MS DTC was unable to start because the installation was not configured to
> run on a cluster. Please create a MS DTC resource through cluster
> administrator. Error Specifics:
> d:\srvrtm\com\complus\dtc\shared\mtxclu\mtxclusetu phelper.cpp:534, Pid:
3192,
> CmdLine: C:\WINDOWS\system32\msdtc.exe
> Could not start the MS DTC Transaction Manager.
> MS DTC Transaction Manager start failed. LogInit returned error 0x3.
>
>
>
>
|||Microsoft has a fix that I have used several times. Free from PSS. Only the web page for version 6 & 7 are not on the net today.
Google shows this though:
Availability of the Windows Server 2003 Post-Service Pack 1 COM+ ...897667 (http://support.microsoft.com/kb/897667/) Availability of Windows Server 2003 Post-Service Pack 1 COM+ 1.5 Hotfix Rollup Package 6 ...
support.microsoft.com/kb/921981 - Similar pages
Could be because SP2 is right around the corner now...
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Shann Lim" <ShannLim@.discussions.microsoft.com> wrote in message news:36DA21D5-FF1C-47D7-82EC-585E86597416@.microsoft.com...
> Hi,
> I have a problem starting my MSDTC.
> I have enable network DTC access (following the instructions in MS KB
> 817064) on two of my servers before I clustered them. The DTC services run
> well. After that, I configured my servers in cluster Node A and B
> (Active/Passive). The DTC immediately failed to start. I carried on and
> configured my MSDTC resources (following the instructions in MS KB 301600) on
> Node A. The other resources like IP, Physical disk, Network name able to
> bring online except for DTC.
> What is happening? I have tried my best to follow all instructions as
> closely as possible. I seems to be struck. Still have to install SQL 2005
> but now spend days to resolve the MSDTC issue. Please kindly help me!
> Thanks a lot in advance!
> Received error like
> MS DTC was unable to start because the installation was not configured to
> run on a cluster. Please create a MS DTC resource through cluster
> administrator. Error Specifics:
> d:\srvrtm\com\complus\dtc\shared\mtxclu\mtxclusetu phelper.cpp:534, Pid: 3192,
> CmdLine: C:\WINDOWS\system32\msdtc.exe
> Could not start the MS DTC Transaction Manager.
> MS DTC Transaction Manager start failed. LogInit returned error 0x3.
>
>
>
>
|||Hi,
I appreciate all the helps.
But may I noe where to d/l the COM+ patch?
Thank you.
"Rodney R. Fournier [MVP]" wrote:
[vbcol=seagreen]
> Microsoft has a fix that I have used several times. Free from PSS. Only the web page for version 6 & 7 are not on the net today.
> Google shows this though:
> Availability of the Windows Server 2003 Post-Service Pack 1 COM+ ...897667 (http://support.microsoft.com/kb/897667/) Availability of Windows Server 2003 Post-Service Pack 1 COM+ 1.5 Hotfix Rollup Package 6 ...
> support.microsoft.com/kb/921981 - Similar pages
>
> Could be because SP2 is right around the corner now...
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Shann Lim" <ShannLim@.discussions.microsoft.com> wrote in message news:36DA21D5-FF1C-47D7-82EC-585E86597416@.microsoft.com...
|||Hi,
Sorry. I think I forgotten to include that I am using Win2k3 SP 1 for my
nodes. THe articles given by Mr Fournier and Mr Mierlo seems to be for
Win2k. Is it applicable for my case?
Thanks again.
"Rodney R. Fournier [MVP]" wrote:
[vbcol=seagreen]
> Microsoft has a fix that I have used several times. Free from PSS. Only the web page for version 6 & 7 are not on the net today.
> Google shows this though:
> Availability of the Windows Server 2003 Post-Service Pack 1 COM+ ...897667 (http://support.microsoft.com/kb/897667/) Availability of Windows Server 2003 Post-Service Pack 1 COM+ 1.5 Hotfix Rollup Package 6 ...
> support.microsoft.com/kb/921981 - Similar pages
>
> Could be because SP2 is right around the corner now...
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Shann Lim" <ShannLim@.discussions.microsoft.com> wrote in message news:36DA21D5-FF1C-47D7-82EC-585E86597416@.microsoft.com...
|||Dear Shann Lim,
http://support.microsoft.com/kb/897667
is for Windows 2003
HTH,
Edwin.
"Shann Lim" <ShannLim@.discussions.microsoft.com> wrote in message
news:D3B191E6-503E-445A-8B0D-20109E5D1E7F@.microsoft.com...[vbcol=seagreen]
> Hi,
> Sorry. I think I forgotten to include that I am using Win2k3 SP 1 for my
> nodes. THe articles given by Mr Fournier and Mr Mierlo seems to be for
> Win2k. Is it applicable for my case?
> Thanks again.
> "Rodney R. Fournier [MVP]" wrote:
the web page for version 6 & 7 are not on the net today.[vbcol=seagreen]
....897667 (http://support.microsoft.com/kb/897667/) Availability of Windows
Server 2003 Post-Service Pack 1 COM+ 1.5 Hotfix Rollup Package 6 ...[vbcol=seagreen]
news:36DA21D5-FF1C-47D7-82EC-585E86597416@.microsoft.com...[vbcol=seagreen]
services run[vbcol=seagreen]
and[vbcol=seagreen]
301600) on[vbcol=seagreen]
to[vbcol=seagreen]
2005[vbcol=seagreen]
to[vbcol=seagreen]
Pid: 3192,[vbcol=seagreen]

MSDTC Resource in the Cluster Group

Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
It's more a matter of usage and availability. If you use it a lot, even
though its small, it takes it toll on the disk. You would never want MSDTC
to take cycles away from what the quorum is trying to use. As for
availability, what happens if you have a resource failure? By default, the
group is afftected. Putting more things in ANY group, affects the group as a
whole. For the Highest Availability, keep everything separate.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:E91F75E1-1006-4062-8BC7-35D94FD3E77F@.microsoft.com...
> Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
> if
> the MSDTC has its own IP Address and Network Name?
> In my planned multiple instance sql cluster, I can see giving up a
> physical
> disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
> doesn't use tons on disk space, can I put it in the same group as the
> defualt
> instance of SQL, again as long has it has its own IP Address and Network
> Name?

MSDTC Resource Group - Physical Disk and Network Name

Article 301600 (http://support.microsoft.com/?kbid=301600) mentions that
MSDTC should be in its own resource group.
- What is the recommended size for the physical disk that needs to be in
this resource group?
- Is it necessary to add the Network Name resource to DNS?
Thank you.
500 MB (meg) or bigger.
You will need an IP and Network Name for it to be on the wire.
If you are running Windows Sever 2003, be sure to follow 817064 FIRST.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"vkb" <vkb@.discussions.microsoft.com> wrote in message
news:48A5C66D-988B-47A1-B638-DA2FC15AEB9B@.microsoft.com...
> Article 301600 (http://support.microsoft.com/?kbid=301600) mentions that
> MSDTC should be in its own resource group.
> - What is the recommended size for the physical disk that needs to be in
> this resource group?
> - Is it necessary to add the Network Name resource to DNS?
> Thank you.

MSDTC in Cluster Group

Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
The original MS KB posts recommended using the Cluster Group resource;
however, we've found out that it does not work and an instance of SQL Server
can not bind to it unless it's on the same node.
You can put it in the SQL Server Group resource, but it won't work once you
go multi-instanced. At that point, MS recommends that you create a seperate
shared disk resource with its own IP and Network Name resources and cluster
MS DTC as a seperate group. Looks like the coders didn't think through the
implications of the Quorum and coded against it. The SQL Server
developement group did not realize this.
Sincerely,
Anthony Thomas

"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:922FDA87-A645-43C7-8442-BAD97525A3F1@.microsoft.com...
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the
defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?

MSDTC in Cluster Group

Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?The original MS KB posts recommended using the Cluster Group resource;
however, we've found out that it does not work and an instance of SQL Server
can not bind to it unless it's on the same node.
You can put it in the SQL Server Group resource, but it won't work once you
go multi-instanced. At that point, MS recommends that you create a seperate
shared disk resource with its own IP and Network Name resources and cluster
MS DTC as a seperate group. Looks like the coders didn't think through the
implications of the Quorum and coded against it. The SQL Server
developement group did not realize this.
Sincerely,
Anthony Thomas
"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:922FDA87-A645-43C7-8442-BAD97525A3F1@.microsoft.com...
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the
defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?

MSDTC connection problem

Hello, I have a very annoying problem:
The Lan network comprises:
A) SQL Server 2005 Express Edition (WindowsXP Sp2)
B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
When I try to run distributed transaction from *A* to *B*, I receive
the error message:
"Transakcja zostaa ju jawnie lub niejawnie przekazana
lub przerwana"
(my translation is: Transaction has been explicitly or
implicitly interrupted or transfered)
When I try to run distributed transaction from *B* to *A*, I receive
the error message:
"No transaction is active."
The transaction is simple, similar to:
begin distributed tran
SELECT * FROM SerwerA.testowa.dbo.tabela;
commit
MSDTC is running on both computers, properly configured (network-aware),
there are no firewalls running, server names are resolvable (they're
placed in the hosts files). What could be the reason for such a
behaviour? I'd be grateful for any kind of help because I'm fighting
with this problem for a few days...
Regards,
Piotr
Piotr Porzucek wrote:
> Hello, I have a very annoying problem:
> The Lan network comprises:
> A) SQL Server 2005 Express Edition (WindowsXP Sp2)
> B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
> When I try to run distributed transaction from *A* to *B*, I receive
> the error message:
> "Transakcja zostaa ju jawnie lub niejawnie przekazana
> lub przerwana"
> (my translation is: Transaction has been explicitly or
> implicitly interrupted or transfered)
> When I try to run distributed transaction from *B* to *A*, I receive
> the error message:
> "No transaction is active."
> The transaction is simple, similar to:
> begin distributed tran
> SELECT * FROM SerwerA.testowa.dbo.tabela;
> commit
> MSDTC is running on both computers, properly configured (network-aware),
> there are no firewalls running, server names are resolvable (they're
> placed in the hosts files). What could be the reason for such a
> behaviour? I'd be grateful for any kind of help because I'm fighting
> with this problem for a few days...
> Regards,
> Piotr
Hi,
Try to take a look at this link - maybe that can lead you on right track.
http://support.microsoft.com/kb/817064/
Regards
Steen Schlter Persson
Database Administrator / System Administrator

MSDTC connection problem

Hello, I have a very annoying problem:
The Lan network comprises:
A) SQL Server 2005 Express Edition (WindowsXP Sp2)
B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
When I try to run distributed transaction from *A* to *B*, I receive
the error message:
"Transakcja zosta³a ju¿ jawnie lub niejawnie przekazana
lub przerwana"
(my translation is: Transaction has been explicitly or
implicitly interrupted or transfered)
When I try to run distributed transaction from *B* to *A*, I receive
the error message:
"No transaction is active."
The transaction is simple, similar to:
begin distributed tran
SELECT * FROM SerwerA.testowa.dbo.tabela;
commit
MSDTC is running on both computers, properly configured (network-aware),
there are no firewalls running, server names are resolvable (they're
placed in the hosts files). What could be the reason for such a
behaviour? I'd be grateful for any kind of help because I'm fighting
with this problem for a few days...
Regards,
PiotrPiotr Porzucek wrote:
> Hello, I have a very annoying problem:
> The Lan network comprises:
> A) SQL Server 2005 Express Edition (WindowsXP Sp2)
> B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
> When I try to run distributed transaction from *A* to *B*, I receive
> the error message:
> "Transakcja zosta³a ju¿ jawnie lub niejawnie przekazana
> lub przerwana"
> (my translation is: Transaction has been explicitly or
> implicitly interrupted or transfered)
> When I try to run distributed transaction from *B* to *A*, I receive
> the error message:
> "No transaction is active."
> The transaction is simple, similar to:
> begin distributed tran
> SELECT * FROM SerwerA.testowa.dbo.tabela;
> commit
> MSDTC is running on both computers, properly configured (network-aware),
> there are no firewalls running, server names are resolvable (they're
> placed in the hosts files). What could be the reason for such a
> behaviour? I'd be grateful for any kind of help because I'm fighting
> with this problem for a few days...
> Regards,
> Piotr
Hi,
Try to take a look at this link - maybe that can lead you on right track.
http://support.microsoft.com/kb/817064/
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator

MSDTC connection problem

Hello, I have a very annoying problem:
The Lan network comprises:
A) SQL Server 2005 Express Edition (WindowsXP Sp2)
B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
When I try to run distributed transaction from *A* to *B*, I receive
the error message:
"Transakcja zostaa ju jawnie lub niejawnie przekazana
lub przerwana"
(my translation is: Transaction has been explicitly or
implicitly interrupted or transfered)
When I try to run distributed transaction from *B* to *A*, I receive
the error message:
"No transaction is active."
The transaction is simple, similar to:
begin distributed tran
SELECT * FROM SerwerA.testowa.dbo.tabela;
commit
MSDTC is running on both computers, properly configured (network-aware),
there are no firewalls running, server names are resolvable (they're
placed in the hosts files). What could be the reason for such a
behaviour? I'd be grateful for any kind of help because I'm fighting
with this problem for a few days...
Regards,
PiotrPiotr Porzucek wrote:
> Hello, I have a very annoying problem:
> The Lan network comprises:
> A) SQL Server 2005 Express Edition (WindowsXP Sp2)
> B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
> When I try to run distributed transaction from *A* to *B*, I receive
> the error message:
> "Transakcja zostaa ju jawnie lub niejawnie przekazana
> lub przerwana"
> (my translation is: Transaction has been explicitly or
> implicitly interrupted or transfered)
> When I try to run distributed transaction from *B* to *A*, I receive
> the error message:
> "No transaction is active."
> The transaction is simple, similar to:
> begin distributed tran
> SELECT * FROM SerwerA.testowa.dbo.tabela;
> commit
> MSDTC is running on both computers, properly configured (network-aware),
> there are no firewalls running, server names are resolvable (they're
> placed in the hosts files). What could be the reason for such a
> behaviour? I'd be grateful for any kind of help because I'm fighting
> with this problem for a few days...
> Regards,
> Piotr
Hi,
Try to take a look at this link - maybe that can lead you on right track.
http://support.microsoft.com/kb/817064/
Regards
Steen Schlter Persson
Database Administrator / System Administrator

MSDTC

Hi all,
I'm new to clustering. Just some question to ask u all.
Do we have to configure separate static ip, network name and physical disk
for the MSDTC?
Or we can use the same static ip, network name and physical disk(Q:quorum
disk) that we configure for server clustering?
Appreciate ur help.
Tks
Message posted via http://www.droptable.com
Current best practice recommendations from Microsoft say to put MSDTC in its
own virtual server. therefore you will need a static IP addres, network
name, and physical disk. It is possible to use the Quorum disk and group
but it is not recommended. If you expect a low volume of Distributed
Transactions, you should be OK sharing one device.
Geoff N. Hiten
Microsoft SQL Server MVP
"Mohd Hidayat via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:947e91d07767474e88186ebbb5ed1539@.droptable.co m...
> Hi all,
> I'm new to clustering. Just some question to ask u all.
> Do we have to configure separate static ip, network name and physical disk
> for the MSDTC?
> Or we can use the same static ip, network name and physical disk(Q:quorum
> disk) that we configure for server clustering?
> Appreciate ur help.
> Tks
> --
> Message posted via http://www.droptable.com
|||Mohd
It is recommended to create a new group with disk, ip, and name resources
available for the MSDTC resource. It is acceptable to use an existing group
if you do not have the resource capasity.
http://support.microsoft.com/default...b;en-us;301600
Regards
CT
"Mohd Hidayat via droptable.com" wrote:

> Hi all,
> I'm new to clustering. Just some question to ask u all.
> Do we have to configure separate static ip, network name and physical disk
> for the MSDTC?
> Or we can use the same static ip, network name and physical disk(Q:quorum
> disk) that we configure for server clustering?
> Appreciate ur help.
> Tks
> --
> Message posted via http://www.droptable.com
>