BAck up into network

Question

BAck up into network

mahtab_ir54

SSC Enthusiast

Points: 124
More actions
June 21, 2010 at 1:43 am

#220215

hi
i want to get backup from my database but i'd like my backup being at the storage , so use hereunder method:
EXEC sp_addumpdevice 'disk',test_backup_set','\\serverip\h:\backupdb\test.BAK'
backup database test to test_backup_set
but i take this error
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'test_backup_set(\\serverip\h:\backupdb2005\test.BAK)'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
what can i do , thanks.

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

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Have you tried opening that UNC path from the database server?

I don't see that working: "\\serverip\h:" should be something like "\\serverip\h$". Even better, it should be a different share from the admin (h$). I suggest that you create a new share and set the permissions both on the share and the target folder in order to allow the service user to read/write on that path.

-- Gianluca Sartori

mahtab_ir54 SSC Enthusiast Points: 124 More actions · Answer 2

mahtab_ir54

SSC Enthusiast

Points: 124

June 21, 2010 at 2:49 am

#1182593

thanks alot for your help

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

You're welcome.

Hope you get it to work.

-- Gianluca Sartori

Randy-574768 Default port Points: 1435 More actions · Answer 4

Another issue to watch for is to be sure that the process running the backup has permissions, such as when you have the SQL Server Agent running the backup from a job. So, if you are using SQLSRVR_SQL_AGENT account that runs jobs, then SQLSRVR_SQL_AGENT account is going to need read/write on that share.

Randy