October 20, 2010 at 4:04 pm
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?
October 21, 2010 at 12:13 am
The SQL Server Agent service account should be a domain account and should have read-write permission to on folder \\machineB\Backup.
October 21, 2010 at 3:13 pm
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?
October 21, 2010 at 11:27 pm
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.
October 27, 2010 at 5:42 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply