sql backup on tape drive

Hi,

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.
LVL 1
prdeshpandeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
0
samsymonCommented:
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.

0
TapeDudeCommented:
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:

     www.aldownloading.com
0
TapeDudeCommented:
Sorry, meant here:

     www.aldownloading.com/manuals/mtf100b.doc
0
Chris MConsulting - 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:
RESTORE VERIFYONLY FROM TAPE = N'\\.\Tape0', NOUNLOAD;

All the best,
Chris Musasizi

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.