Post reply

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

  • 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

  • May 19, 2009 at 6:41 am

    #996880

    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.

  • May 19, 2009 at 7:58 am

    #996979

    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?

  • May 20, 2009 at 12:53 am

    #997401

    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

  • May 20, 2009 at 1:11 am

    #997410

    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?

  • May 20, 2009 at 3:00 am

    #997457

    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

  • May 20, 2009 at 5:17 am

    #997498

    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.

  • May 20, 2009 at 8:10 am

    #997616

    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!

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

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