Stored Procedure to read tape backup log

By Neil Jacobson, 2002/02/10

Total article views: 214 | Views in the last 30 days: 5

Rate this |

Join the discussion |

Briefcase

If you need to check that the tape back of your database backup files was successful, you would generally read the errorlog for the backup software.

If you are just interested in today's results or a particular day's log it can be a pain to get. You could have a shortcut on the desktop or you could get SQL to do the reading for you.

I wrote this stored procedure to give me todays content from the tape backup log. If I pass it a string containing the date e.g. '20020202' it will return entries for that day.

It can be easily adapted for reading just about any text file.

By Neil Jacobson, 2002/02/10

Total article views: 214 | Views in the last 30 days: 5

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Recompile Views/SPs from DOS from .SQL Files.

By Mindy Curnutt | Category: Miscellaneous

| 464 reads

Re-create Transaction log file

By philcart | Category: Miscellaneous

| 634 reads

sp_GetLastBackup

By TJay Belt | Category: Miscellaneous

| 307 reads

sp_GetBackupInfo

By TJay Belt | Category: Miscellaneous

| 628 reads

Like this? Try these...

Get the current state of triggers.

By James Travis | Category: Miscellaneous

| 396 reads

UDF to get Day of the Year

By schawdhury | Category: Miscellaneous

| 165 reads

How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2005

By Additional Articles | Category: SQL Server 2005

Rate this | 2,613 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com