I having a question is how to backup my database into the external storage. i can simply mapping a network drive from my pc and backup database directly to my pc hardisk from the server. but in this case, I need to backup directly go to my external storage, bbut it can't display the network drive for me when i click 'backup database'. what should i need to do?



Thanks and Regards

Jane

In the Query Analyzer

-- Create a logical backup device for the full database backup
USE master
EXEC sp_addumpdevice 'disk', 'networkdevice',
   '\\servername\sharename\path\filename.ext'

-- Back up the full MyDB database.

BACKUP DATABASE MyDB TO networkdevice

may i know \\servername\sharename\path\....
in detail.

\\servername is it my SQL server name?

\sharename is it my external storage name?

\how about the \path\?

I am not sure what you have meant by external storage on your post, assuming it is a shared network drive

Servername is the machinename you wanted to save your backup files on your windows network, backup and SQLdB are the folders on that server

\\BackUpServerName\backup\SQLDB\filename.BAK

Please make sure that account under which SQL server is running MUST have permissions on that network folder (you might want to run your SQL server service under Windows network domain administrator account)

if in doubt check the Books Online (which is installed when you install your SQL Server)