Home > IT Answers > Storage > DB backup onto External Hardrive
KH
155 pts.
 DB backup onto External Hardrive
Backup, External hard drives, SQL Backup, SQL Server, SQL Server backup
Hi

I have connected an external USB hard drive to my SQL server (2000). When i attempt to backup from Enterprise manager (to the harddrive) i cant seem to find the drive in the list. The drive has been made active (active partition) and can be used from windows explorer without any problems.

I would appreciate it if someone can tell me if i have missed something.

Thanks



Software/Hardware used:
SQL Server, Backup
ASKED: March 10, 2011  4:52 PM
UPDATED: March 12, 2011  2:30 AM
RELATED QUESTIONS
Answer Wiki:
Hi I have sorted the problem, the SQL service account must be allowed FULL control on the drive. Thanks anyway
Last Wiki Answer Submitted:  March 11, 2011  10:38 am  by  KH   155 pts.
All Answer Wiki Contributors:  KH   155 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

before this was it a normal user account? because if you did hardening, there are some rules stating that you cannot do this and that and only administrator can do it

jinteik
 15,485 pts.