Networker

Re: [Networker] Sybase DB restore

2008-05-19 18:56:26
Subject: Re: [Networker] Sybase DB restore
From: Tim Mooney <Tim.Mooney AT NDSU DOT EDU>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Mon, 19 May 2008 17:51:53 -0500
In regard to: Re: [Networker] Sybase DB restore, Curtis Preston said (at...:

Since you weren't using the agent, how were you backing it up?  Given
the scenario you describe, though, I'm fearing the answer is that you
weren't.
I'm suspicious of that too.

 There are a number of possiblities here:

1. You weren't shutting down the DB during backup, so the file was
apparently open and changing during backup.  The file was therefore
skipped and isn't available for restore.
Files on UNIX and Linux systems aren't skipped just because they're open,
so if the server was a UNIX or Linux box, it would still have been backed
up (barring any directives that told NetWorker to skip those files).
You're right, though, that it would be garbage if the database
changed at all during the backup (and possibly even if it didn't).

 2. The database is on raw
partitions which aren't backed up by default.
3. You were backing up the database using a script and "dump database"
to disk, but you didn't back up THAT file.

How WERE you backing it up?
...And what platform is the server?

Tim
--
Tim Mooney                                        Tim.Mooney AT ndsu DOT edu
Information Technology Services                   (701) 231-1076 (Voice)
Room 242-J6, IACC Building                        (701) 231-8541 (Fax)
North Dakota State University, Fargo, ND 58105-5164

To sign off this list, send email to listserv AT listserv.temple DOT edu and type 
"signoff networker" in the body of the email. Please write to networker-request 
AT listserv.temple DOT edu if you have any problems with this list. You can access the 
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

<Prev in Thread] Current Thread [Next in Thread>