October 1, 2008 at 11:23 am
I am trying to back up a SQL Server Express Edition database across a domain network. The database resides on Windows Server 2003, and I am trying to backup to a shared folder called "SQL Backup" on my WinXP Pro desktop.
I am running a script in SS Management Studio on the WinXP (SS Standard) while connecting to the Express database engine located on the server.
The permissions on the share are for my domain login, full control. I have tested and am able to copy files to it from the server, however when I try to run the backup, I get an error referencing that I do not have the proper permissions set.
The script is:
BACKUP DATABASE MyDatabase
To disk = '\\MyComputer\SQL Backup\MyDatabase.bak'
GO
Error Message that I get:
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\MyComputer\SQL Backup'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Any assistance would be appreciated.
October 1, 2008 at 1:18 pm
are you running the express instance under local system account, because that cannot perform any functions across the network.
two different things to try
on the destination server give the source server network admin account rights to the share (serveretwork$). You could backup the database to local disk first then xcopy or robocopy it across (this is more reliable than backup across the network)
set up a domain user and make this the service account SQL runs under. Give this account rights to the share.
---------------------------------------------------------------------
October 1, 2008 at 2:04 pm
George has it right, but don't make an admin or domain admin, use a regular user. Once the user is created (should be a strong password on an account no one uses), be sure you use the SQL Server Configuration Manager to change the service account. It will set the correct permissions.
October 1, 2008 at 2:43 pm
Thanks both George and Steve. It worked! Steve - thanks a bunch for the addtional tip on the admin/regular user.
October 1, 2008 at 3:06 pm
george sibbald (10/1/2008)
on the destination server give the source server network admin account rights to the share (serveretwork$). quote]
sorry about the silly typo, that should be domain\servername$
---------------------------------------------------------------------
October 2, 2008 at 6:14 am
Thanks George.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply