i have a stored procedure that backups database on server A which i execute this SP from server B in a scheduled job. when i run this job it gives me an error:
Executed as user: domain\user_name. Could not relay results of procedure 'usp_BackupDBOnServerA' from remote server 'ServerB'. [SQLSTATE 42000] (Error 7221) [SQLSTATE 01000] (Error 7312). The step failed.
i searched MS KB, everywhere but could not find the solution or even explanation why this happenning.
both sql servers are 2000 and they are linked.It seems like an account permissions issue. I would look over the SP and make sure that the account which SQLServer service, SQLAgent service, and the scheduled job has access to the SP as well as the network share which the backup is being written too.
Does the whole backup fail or does it just not return what happened (the result or output)?|||actually there's no issue with account's permissions. and to asnwer your question the job itself fails.
but i just figured out how to solve the issue: i increased the Remote query timeout in the Server properties.
thanks for the help anyway.|||Great! Thanks for posting the answer, it helps with other people who might run into the same problem.
Showing posts with label remotely. Show all posts
Showing posts with label remotely. Show all posts
Sunday, March 11, 2012
Tuesday, February 14, 2012
Backup
I'm working with a database server placed in a datacenter remotely placed fr
om my work location, and accessing the database through Enterprise Manager a
nd Quesry Analyser connected via Internet.
The backup is scheduled and log-shipping is implemented with another server
in the datacenter. But I want to take backup and store backup files in my lo
cal machine. Can I do this or I have to get the files from the database ser
ver through some FTP or oth
er protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK =
N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...
from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.
server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.
I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...
can I use \\ unc path.
om my work location, and accessing the database through Enterprise Manager a
nd Quesry Analyser connected via Internet.
The backup is scheduled and log-shipping is implemented with another server
in the datacenter. But I want to take backup and store backup files in my lo
cal machine. Can I do this or I have to get the files from the database ser
ver through some FTP or oth
er protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK =
N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...
quote:
> I'm working with a database server placed in a datacenter remotely placed
from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.
quote:
> The backup is scheduled and log-shipping is implemented with another
server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.
quote:|||When I'm accessing the database server through the internet link so how can
>
> Thanks in advance but plz do help me
I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...
quote:
> When I'm accessing the database server through the internet link so how
can I use \\ unc path.
Sunday, February 12, 2012
Backup
I'm working with a database server placed in a datacenter remotely placed from my work location, and accessing the database through Enterprise Manager and Quesry Analyser connected via Internet.
The backup is scheduled and log-shipping is implemented with another server in the datacenter. But I want to take backup and store backup files in my local machine. Can I do this or I have to get the files from the database server through some FTP or other protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK = N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...
> I'm working with a database server placed in a datacenter remotely placed
from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.
> The backup is scheduled and log-shipping is implemented with another
server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.
>
> Thanks in advance but plz do help me|||When I'm accessing the database server through the internet link so how can I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...
> When I'm accessing the database server through the internet link so how
can I use \\ unc path.
The backup is scheduled and log-shipping is implemented with another server in the datacenter. But I want to take backup and store backup files in my local machine. Can I do this or I have to get the files from the database server through some FTP or other protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK = N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...
> I'm working with a database server placed in a datacenter remotely placed
from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.
> The backup is scheduled and log-shipping is implemented with another
server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.
>
> Thanks in advance but plz do help me|||When I'm accessing the database server through the internet link so how can I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...
> When I'm accessing the database server through the internet link so how
can I use \\ unc path.
Subscribe to:
Posts (Atom)