How to backup MSSQL database into Network Shared Drive

[Former Member]

HI Gurus, Right now i need to backup the sap database into Network shared drive. When i go to MSSQL Studio >Databases> Then choose the instance that u want to backup which is IDS-->Right click on (IDS) and then click on TASKS --> BACKUP. Then i choose full database backup. Then when i want to choose the destination for the backup i only can choose the LOCAL hard drive installed on the server. I cant find an option to choose to backup on NETWORK STORAGE drive. Can someone help me configure that please. I dont have tape drive to backup on it so that option is disabled. So HOW TO BACKUP THE DATABASE INTO NETWORK STORAGE DRIVE. I really appreciate your prompt reply. Thank you.

[Former Member · Accepted solution]

Hi,

you have to add a dump device in order to backup to a network share. After adding the dump device you can select it in your backup options. Check this [link|http://msdn.microsoft.com/en-us/library/ms188409.aspx] and have a look at example B.

Sven