Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

add comment

1 Answer 1

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
add comment

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