how do I know files are backed up in tapes

Question

how do I know files are backed up in tapes

sqlfriend

SSC Guru

Points: 52769
More actions
January 13, 2013 at 5:24 pm

#272759

We have maintenance plan setup for back ups.
But we also have tape backup for the backup files.
My question is from server NTFS system, how can I know if the files are backed up in tapes, any marks ?
Thanks,

Viewing 5 posts - 1 through 4 (of 4 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

You need to explore the tape index/catalog/contents to see if the files were backed up. Better yet is to test restore from tape.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 2

Jason is, of course, spot on for this. You have to see it to believe it.

As a sidebar, though, this is precisely what the DOS level "archive" bit is for. Any decent tape backup worth it's salt will turn the bit off at the file level once the file has been backed up. It's easy to see from windows explorer. Just open the directory, right click on the headers, and include the "attributes" column". An "A" in that column means that the archive bit is still set.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sqlfriend SSC Guru Points: 52769 More actions · Answer 3

As a sidebar, though, this is precisely what the DOS level "archive" bit is for. Any decent tape backup worth it's salt will turn the bit off at the file level once the file has been backed up. It's easy to see from windows explorer. Just open the directory, right click on the headers, and include the "attributes" column". An "A" in that column means that the archive bit is still set.

Thanks, that is exactly what I want to know.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Keep in mind that unless you test restore the files - you have no backup.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events