Backup on shared folder

Question

Backup on shared folder

krishna83

Ten Centuries

Points: 1003
More actions
May 8, 2017 at 6:42 am

#323406

How to run SQL server backup on a shared folder?

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

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

Thom A SSC Guru Points: 99130 More actions · Answer 1

Could you elaborate a bit more? Do you simply mean you wish to create a backup on a shared folder on the network? For example (without any WITH clauses):
BACKUP DATABASE [YourDatabase] TO DISK = '\\YourServer\SharedDirectory\SubDirectory\YourBackupFile.bak';

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

krishna83 Ten Centuries Points: 1003 More actions · Answer 2

BACKUP DATABASE ABC_123 TO DISK = '\\WIN-94EATCLRNI5\Backup\ABC_123.bak';

Msg 3201, Level 16, State 1, Line 13
Cannot open backup device '\\WIN-94EATCLRNI5\Backup\ABC_123.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 13
BACKUP DATABASE is terminating abnormally.

I am getting above error while running backup on a shared folder.

Thanks & Regards
Krishna.

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 3

krishnabudampati - Monday, May 8, 2017 11:22 PM
BACKUP DATABASE ABC_123 TO DISK = '\\WIN-94EATCLRNI5\Backup\ABC_123.bak';
Msg 3201, Level 16, State 1, Line 13
Cannot open backup device '\\WIN-94EATCLRNI5\Backup\ABC_123.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 13
BACKUP DATABASE is terminating abnormally.
I am getting above error while running backup on a shared folder.
Thanks & Regards
Krishna.

You should check if the account under which the SQL Server service runs has the full rights on the shared folder.
Have you checked that?

Igor Micev,My blog: www.igormicev.com

krishna83 Ten Centuries Points: 1003 More actions · Answer 4

I am fresher to SQL server, Could you please let me know how to check permissions.

Thanks & Regards
Krishna.

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 5

krishnabudampati - Tuesday, May 9, 2017 1:12 AM
I am fresher to SQL server, Could you please let me know how to check permissions.
Thanks & Regards
Krishna.

You don't do that via SSMS or SQL server. Simply check them on the folder - https://technet.microsoft.com/en-us/library/cc754344(v=ws.11).aspx
or ask the sys or network admin to do that for the sql server account.

Igor Micev,My blog: www.igormicev.com