Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


backup history


backup history

Author
Message
charipg
charipg
Mr or Mrs. 500
Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)Mr or Mrs. 500 (506 reputation)

Group: General Forum Members
Points: 506 Visits: 1193
Hi,

i want to know the database backup history.

It means , i want a query to generate the list of database name and backup time.

thanks,
kiran
c00ler01
c00ler01
SSC-Enthusiastic
SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)

Group: General Forum Members
Points: 126 Visits: 102
Hi,
1. Use DOS command to list all files in a given location.
2. Execute that through SQL and store results in a table with a time stamp.

You'll see backup file growth over the period of time. If it's too much info than list servers instead of single databases.

Problem with this is if the backup fails you'll need a seperate process or to analyse the job logs.

Another problem us that there is no way to establish partial writes.


Would be nice to hear alternatives,preferably something that doesn't involve SSRS
Gethyn Ellis
Gethyn Ellis
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1066 Visits: 2842
This script here probably answers your question:

http://www.mssqltips.com/tip.asp?tip=1601

Gethyn Ellisgethynellis.com
c00ler01
c00ler01
SSC-Enthusiastic
SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)

Group: General Forum Members
Points: 126 Visits: 102
I have read the article on MSSQL Tips website.

The system views do provide useful information about the backups.

In my opinion, the following things are missing:

1. In their example, you can check if the backup has run in the past 24 hours by doing a select on a system view. This works on the assumption that the backup must run at least once. What you could have, is a backup schedule table where you as a DBA can specify what type of backup you want to perform and how often.
2. I believe those system views are missing in SQL 2000, you'll have to check this.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search