Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 has been asked before and already has an answer. If those answers do not fully address your question, please ask a new 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.