what may be the cause if backup file is not reaching to the tape?

Question

what may be the cause if backup file is not reaching to the tape?

abhi4u86

SSC Veteran

Points: 281
More actions
May 19, 2009 at 3:26 am

#132551

Hi all,
what may be the cause if backup file is not reaching from SQL Server to tape?
&
if backup has reached to the tape then what may be the cause if backup file is not removing from SQL Server?
Plz answer these 2 Question.
Regards,
Abhishek

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

CrazyMan SSChampion Points: 12560 More actions · Answer 1

there might be various factors which affects this, are you backing directly to the tape, can you post in your SQL, so every one can have a look.

David Sorauer SSCrazy Points: 2874 More actions · Answer 2

The account that runs the tape backup process will need sa rights in SQL Server if it needs to create a virtual dump device. Could that be the issue?

abhi4u86 SSC Veteran Points: 281 More actions · Answer 3

hi all,

thanks 4 ur sugesstion,

but sometimes bakeup file reaches on the tape & sometimes does not,

so what may be the cause of delay?

same problem occurs with removing of backup file from server when it reached to tape,

sometime bakeup file removed automaticaly & sometimes delayed.

these 2 problems i m facing since 3-4 months,

so kindly give me some suggestion what to do in this situation ?

Regards,

Abhishek

David Sorauer SSCrazy Points: 2874 More actions · Answer 4

This is a tape backup question, not SQL Server right?

Maybe better to ask Windows admins (rather than DBAs)? What backup software are you using anyway?

abhi4u86 SSC Veteran Points: 281 More actions · Answer 5

ya david, its a tape backup question so i thnk u mean to say this is not the DBA's job to takecare of it,

well thanks alot...

one more question ,i need ur sugesstion on that

in the situation of blocking of processes, is there any alternative apart from killing that blocking process or is this only one solution?

regards,

abhishek

JamieX Hall of Fame Points: 3763 More actions · Answer 6

same problem occurs with removing of backup file from server when it reached to tape

This is confusing.. Are you saying you backup file to disk, then tape picks it up from filesystem?

If this is the case you need to sit down with your backup admin and fix the timing of your backups. You could have a situation where sometimes SQL is still backup up the file (so the tape copy cannot back up a file in use) or the tape is backing up the file (so the SQL agent cannot delete the old files).

Never say "it's not my responsibility".... Unless you want go get fired on the next corrupted database that happens.

David Sorauer SSCrazy Points: 2874 More actions · Answer 7

I really think you need to post more information if you want people to help you...

We don't know if you are talking about an open file agent type backup (that is using virtual dump devices to take an image of the database at a point in time, or are backing up databases to .bak file and then the tape backup process backs up the flat file.

I'm not sure about others, but I have always worked in an environment where tape backups are managed by another infrastructure team who manage windows servers (of course the DBA would consult regarding backup times and strategies).

I suspect many other SQL DBAs working in large organisations wouldn't have extensive knowledge of tape backup processes, rather focusing on native backups...just my 2c!