Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
SQL Server database on an external hard disk drive

I want to take the backup of our companys SQL Server 2008 databalse in an External Drive which is hosted in Windows 2008 server. But when I try to schedule the backup thru maintainance window of Sql Server Management Studio, my external device drive is not displayed. How can I access this device thru mainitainance window and take the backup.

share|improve this question

marked as duplicate by gbn, Ward, rnxrx, Chris McKeown, Michael Hampton Sep 6 '12 at 22:52

This question was marked as an exact duplicate of an existing question.

If the drive is directly connected then just enter the drive letter into the destination box. If it is a network drive then you need to enable sharing and specify the UNC path in the destination box. SSMS just seems to show local drives.

share|improve this answer
We are using Windows 2008 Server. Its not accepting the Drive letter when I tried to access the same. – Venkatesh.A Oct 2 '11 at 15:34
Yes but is it a local drive or a share? – RMacy Oct 26 '11 at 22:58

Not the answer you're looking for? Browse other questions tagged or ask your own question.