sql backup on tape drive


i have written a code for taking daily backups of my sharepoint sites on my san drive but due to some space constraints i have to move it daily onto tape drive....is there any way wherein i can directly put these backups in the tape drive.
i am currently specifying the path as I:/backup in my code.
i cannot do it through the sql management as there is a issue with the installation of agent.
Who is Participating?
Chris MConnect With a Mentor Consulting - Technology ServicesCommented:
I will shed some light in your query:
Note that a Sharepoint backup is different from a database backup of your Sharepoint database(s) in the SQL instance.
For starters, your Sharepoint while your database backup of your Sharepoint databases can only be done from SQL.

From the way you sound, you seem to refer to the database backup of your Sharepoint database(s) using SQL server.

To backup to tape from SQL server, use the following script:

BACKUP DATABASE [Your_Sharepoint_DB] TO TAPE = N'\\.\Tape0', NOUNLOAD;

Remember to verify your backup on tape after as follows:

All the best,
Chris Musasizi

Raja Jegan RSQL Server DBA & ArchitectCommented:
what kind of tape drive you are using.can u access it like a drive.if so then you can manually specify the drive letter "  I:/ " to that device.

it can be done with the help of disk management tool.

you can take it from right click my computer->manage->disk management.

I'm not sure I understand your question, but if you're asking if it's possible to write your own tape-backup software, the answer is yes.

The name of the (first) tape device is \\.\Tape0. You can open it with the standard API call CreateFile, and write/read to/from it with WriteFile and ReadFile.

If you're going to store more than one file per tape you'll need to come up with a format to store Metadata (things like file name, date, size etc). You could use Microsoft's own tape format MTF, which is a reasonably straightforward and published standard, and one which BackupExec, Arcserve & NTBackup can all read. You can download the spec from here:

Sorry, meant here:

All Courses

From novice to tech pro — start learning today.