Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Are Your Database Backups Current and Available? Expand / Collapse
Author
Message
Posted Tuesday, February 21, 2006 2:38 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:39 AM
Points: 2,917, Visits: 468
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/tlarock/areyourdatabasebackupscurrentandavailable.asp

----------------------
http://thomaslarock.com
Post #260407
Posted Tuesday, March 21, 2006 4:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 2, 2014 8:28 AM
Points: 6, Visits: 163

I have a similar process which runs a sproc on each server which performs a LOAD HEADERONLY on each dump device which populates a central db with details of the backups for each server and database. A website and email notification lets me know if there are any databases without current backups on disk.

It's been working well for several years.

Post #267222
Posted Tuesday, March 21, 2006 6:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 7:11 AM
Points: 4, Visits: 65

anyone got a job that will: 1. create a test database; 2. restore a backup into the test database; 3.  verify that the restore succeeded; 4.  delete the test database.

Now that would be a good test of current/available backups!




Post #267237
Posted Tuesday, March 21, 2006 7:47 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 25, 2009 6:14 AM
Points: 876, Visits: 78
Thomas LaRock, you are my new hero!

Artificial Intelligence stands no chance against Natural Stupidity.
Post #267272
Posted Tuesday, March 21, 2006 8:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, January 24, 2014 6:46 AM
Points: 153, Visits: 47
I can't seem to find either the download or DBA_Verify_File_Exists procedure.


Post #267295
Posted Tuesday, March 21, 2006 9:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 10, 2007 7:48 AM
Points: 17, Visits: 1

Although I am new at this, it didn't take long to get this set up on my workstation, and its great!.  The question I have is, how do I get this to check all of the servers, or do I just have to set it up on each server?

N Lytle




NLytle
Post #267325
Posted Tuesday, March 21, 2006 9:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 21, 2006 11:15 AM
Points: 1, Visits: 1
Where can I find the zip files that contains the store procs? Thanks.
Post #267328
Posted Tuesday, March 21, 2006 9:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:00 PM
Points: 33,204, Visits: 15,354
My apologies!!!!

The code is now linked at the bottom of the article.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #267338
Posted Wednesday, March 22, 2006 7:21 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 8:45 AM
Points: 627, Visits: 2,169
But as I understand it, in SQL2K5 they are really restricting xp_cmdshell. Or has that changed?



----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
Post #267563
Posted Wednesday, March 22, 2006 12:31 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:39 AM
Points: 2,917, Visits: 468
Thanks Mom, always nice to hear from you.

----------------------
http://thomaslarock.com
Post #267712
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse