SQL Server Backup

I wanted to know if you need the Enterprise version of SQl server 2005 to backup the databases directly to a tape drive.  I have been trying to back up my DB's on the tape but that option is grayed out for me and I cannot seem to switch the option, currently I am only able to back up on the local drive.  I have the SQL server 2005 standard version and was wondering if it is worth upgrading from the Standard to the Enterprise version.

MTMondayAsked:
Who is Participating?
 
YveauConnect With a Mentor Commented:
Did you create a backup device for your tape library ?

Check this out:
http://msdn2.microsoft.com/en-us/library/ms191316.aspx

Hope this helps ...
0
 
YveauCommented:
Glad I could be of any help !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.