Sql Server 2008 Backup in External Hard Disk Drive

Question

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.

score 0 · Answer 1 · answered Oct 01 '11 at 20:04

0

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.

answered Oct 01 '11 at 20:04

Ryan

101
1

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

Sql Server 2008 Backup in External Hard Disk Drive

1 Answers1