Backup in other machine

Question

Backup in other machine

Helical Johan

Ten Centuries

Points: 1033
More actions
October 20, 2010 at 4:04 pm

#228208

Hi,
I have a database in the machine A, but I need the backup in the machine B. In my maintenance plan put in Folder \\machineB\Backup. It folder requires user and pass :(. I can´t remove this security in the folder.
How can I do it?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

The SQL Server Agent service account should be a domain account and should have read-write permission to on folder \\machineB\Backup.

Helical Johan Ten Centuries Points: 1033 More actions · Answer 2

Thanks, I change the account that start the sql agent service, but it don´t work.

It is the error:

Executed as user: V3\v3backup. ...n 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:26:36 PM Progress: 2010-10-21 14:26:36.92 Source: {BEC3FAD4-7BE1-454C-AA6C-F78BD027605A} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2010-10-21 14:26:37.73 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [CallCenter] TO DISK = N'\\10.16.40.180\v3\CC\CC_backup_201010211426.bak' WITH NOFORMAT, NOINIT, NAME = N'CallCenter_backup_20101021142637', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Cannot open backup device '\\10.16.40.180\v3\CC\CC_backup_201010211426.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problem... The package execution fa... The step failed.

Must I change the account the start the sql service?

Ray Mond SSCertifiable Points: 7159 More actions · Answer 3

Have you manually check if you are able to read/write to the network share, perhaps using Windows Explorer, when logged on as the same account as that used by your SQL Server Agent service?

SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.

Ramesh @ SQLCentral SSC Veteran Points: 246 More actions · Answer 4

Try to access the file using xp_cmdshell 'dir \\machineB\Backup' to check whether SQL Server is able to access.

If you are still getting error, try by giving write permission for the backup path to the SQL Server service account apart from SQL Server agent account then try to take the backup.