Database backup to a remote server

Hi All,
I am trying to do a backup of the SQL Server database to a remote server. I
tried mapping the remote server to the server that has the SQL Server
installed and then specifying the drive letter and the folder. I also tried
giving the complete path - \\ipaddress\folder\backup.bak but I got a error
message. Can someone please let me know what's the correct way of doing this?
Thanks in advance.
Hi
SQL Server and SQL Server agent need to run under a Domain Account that has
permissions on the destination server and share.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sharman" wrote:

> Hi All,
> I am trying to do a backup of the SQL Server database to a remote server. I
> tried mapping the remote server to the server that has the SQL Server
> installed and then specifying the drive letter and the folder. I also tried
> giving the complete path - \\ipaddress\folder\backup.bak but I got a error
> message. Can someone please let me know what's the correct way of doing this?
> Thanks in advance.
|||Hi,
1.You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharenameXX\dbname.bak'
with init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
SQL Server MVP
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:CDA2BE2A-EC9C-4519-A4CA-3D97EEAF0A64@.microsoft.com...
> Hi All,
> I am trying to do a backup of the SQL Server database to a remote server.
> I
> tried mapping the remote server to the server that has the SQL Server
> installed and then specifying the drive letter and the folder. I also
> tried
> giving the complete path - \\ipaddress\folder\backup.bak but I got a error
> message. Can someone please let me know what's the correct way of doing
> this?
> Thanks in advance.

Database backup to a remote server

Hi All,
I am trying to do a backup of the SQL Server database to a remote server. I
tried mapping the remote server to the server that has the SQL Server
installed and then specifying the drive letter and the folder. I also tried
giving the complete path - \\ipaddress\folder\backup.bak but I got a error
message. Can someone please let me know what's the correct way of doing this
?
Thanks in advance.Hi
SQL Server and SQL Server agent need to run under a Domain Account that has
permissions on the destination server and share.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sharman" wrote:

> Hi All,
> I am trying to do a backup of the SQL Server database to a remote server.
I
> tried mapping the remote server to the server that has the SQL Server
> installed and then specifying the drive letter and the folder. I also trie
d
> giving the complete path - \\ipaddress\folder\backup.bak but I got a error
> message. Can someone please let me know what's the correct way of doing th
is?
> Thanks in advance.|||Hi,
1.You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename__\dbname.bak'
with init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
SQL Server MVP
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:CDA2BE2A-EC9C-4519-A4CA-3D97EEAF0A64@.microsoft.com...
> Hi All,
> I am trying to do a backup of the SQL Server database to a remote server.
> I
> tried mapping the remote server to the server that has the SQL Server
> installed and then specifying the drive letter and the folder. I also
> tried
> giving the complete path - \\ipaddress\folder\backup.bak but I got a error
> message. Can someone please let me know what's the correct way of doing
> this?
> Thanks in advance.

Database backup to a remote server

Hi All,
I am trying to do a backup of the SQL Server database to a remote server. I
tried mapping the remote server to the server that has the SQL Server
installed and then specifying the drive letter and the folder. I also tried
giving the complete path - \\ipaddress\folder\backup.bak but I got a error
message. Can someone please let me know what's the correct way of doing this?
Thanks in advance.Hi
SQL Server and SQL Server agent need to run under a Domain Account that has
permissions on the destination server and share.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sharman" wrote:
> Hi All,
> I am trying to do a backup of the SQL Server database to a remote server. I
> tried mapping the remote server to the server that has the SQL Server
> installed and then specifying the drive letter and the folder. I also tried
> giving the complete path - \\ipaddress\folder\backup.bak but I got a error
> message. Can someone please let me know what's the correct way of doing this?
> Thanks in advance.|||Hi,
1.You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename­­\dbname.bak'
with init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
SQL Server MVP
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:CDA2BE2A-EC9C-4519-A4CA-3D97EEAF0A64@.microsoft.com...
> Hi All,
> I am trying to do a backup of the SQL Server database to a remote server.
> I
> tried mapping the remote server to the server that has the SQL Server
> installed and then specifying the drive letter and the folder. I also
> tried
> giving the complete path - \\ipaddress\folder\backup.bak but I got a error
> message. Can someone please let me know what's the correct way of doing
> this?
> Thanks in advance.

Data Type in Parameter Mapping for an Execute SQL Task

Hi, I am trying to use an integer as input parameter for my task I get suck on the parameter data type.

The input parameter is define as @.Control_ID variable as Int32 in SSIS. When I got into the parameter mapping of Execute SQL Task, I don't find the Int32 data type. I used to try Short, Numeric, Decimal and so on, but all of those data type didn't work. and it returns the following error message:

SSIS package "DCLoading.dtsx" starting.
Error: 0xC002F210 at Update Control_ID, Execute SQL Task: Executing the query "use DCAStaging

update DCA_HFStaging set
[dbo].[Control_ID] = P0 where [Control_ID] is null
" failed with the following error: "The multi-part identifier "dbo.Control_ID" could not be bound.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Update Control_ID
Warning: 0x80019002 at DCLoading: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "DCLoading.dtsx" finished: Failure.

Any help?this link might help: http://www.sqlis.com/default.aspx?58|||Thanks for the response. The link you posted is helpful, but does not include the example that I need. I want to set an Int32 variable as intput parameter, but I don't find any integer type in the parameter mapping. And, if I set the SSIS variable as string type, in the parameter mapping, I set the input parameter as varchar, it will return error said the parameter length can't be defined.