Cannot detect external hard disk as backup directory in SQL Server 2005 cluster

Question

Hi All,

I want to backup a 1.3TB database in SQL server cluster environment. I don't have enough local disk space so I think about using an external hard disk to do the backup. However, I cannot find the external hard disk as backup destination from SQL management studio. I have tried to add a file share resource point to external hard disk but cannot bring the resource online, change the database file location to external hard disk but the disk not detected, create new backup devices as the external hard disk but no luck.

How can I use the external hard disk for backup/restore in SQL cluster environment? If it is in single SQL server scenario, can the external hard disk can be detected from SQL management studio automatically?

Thanks.

Answer 1

Hello,

Please see the following article:

http://support.microsoft.com/kb/927797

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hi JPOlas,

Do you attempt to backup SQL Server to a network shared folder?  If that is the case, please make sure that you have configured with the steps below before backup:

• Create a network share from the remote server.
• Provide Full privilege for the SQL Server account to read and write data to the share. For more information: Configuring SQL Server service account security for network resources access.

In addition, please note that the time of SQL Server backup is directly proportional to network bandwidth. And the increased I/O activity has the potential for a negative impact on performance and your system availability.

There are other ways you can workaround this issue, please take a look at this article on How to Backup SQL Server to a Network Shared Folder.

 

---

Best Regards,
Stephanie Lv

Answer 3

I agree with all above answer but There is short way to get backup quickly if you dtabase to large and critical.

Please use STRIPE device backup , it will depend onto your CPU configuration , it will be faster then other backup strategy.

Folow Steps below :-

1) Full Backup  [ Weekly ]

2) Differential backup [ Daily ]

3) Log Backup [ as per your feasibility .

Answer 4

Dear Alberto,

I have a 3TB removable HDD connect to my SQL Server 2005 by usb port (D: drive in My Computer). I want to backup my databases to this HDD.

When I right click my db --> Tasks --> Backup --> at "Backup Destination" choose Disk --> then click Add
I cannot see D: Drive in list

I read the article at   but still confused, I can find my removable hdd at registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\USB\Vid_1058&Pid_1140

How I can backup my DB to a removable HDD ?