OK, so looking at the rendered log on the server shows me that it *is*
backing up every database. But the notification email seems to be
suppressing line, so I wasn't seeing the full list of all databases it is
backing up. Anybody know how to tell the SQL Module to not suppress lines,
so I can see the full list of databases backed up, in a notification
email, so I don't have to render the log to verify that all databases were
backed up properly?
--
Michael Leone
Network Administrator, ISM
Philadelphia Housing Authority
2500 Jackson St
Philadelphia, PA 19145
Tel: 215-684-4180
Cell: 215-252-0143
<mailto:michael.leone AT pha.phila DOT gov>
EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU> wrote on
09/14/2011 09:05:30 AM:
> From: Michael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> Date: 09/14/2011 09:07 AM
> Subject: [Networker] Confused about restoring a copy of a database
> using SQL Module
> Sent by: EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>
>
> I'm confused about something. Recently I had to restore 3 SQL databases
> that had been backed up by the NW SQL Module, from a SQL server that no
> longer exists. So I did a "copy" restore, and the files came over and
are
> now in the new destination SQL server. This destination SQL server has
> both a default instance and a named instance; I restored to the default
> instance. If I use the SQL Management Studio, and go to that default
> instance, I see my 3 restored databases in the list of databases. And I
> can click on them, see the list of tables within the database, etc.
>
> So I think I restored them correctly. :-)
>
> But: I don't see them in the list of databases backed up by the SQL
Module
> of the destination server. And I don't understand that at all. My backup
> job lists "MSSQL:" as the saveset, and "nsrsqlsv" as the backup
command.
> Shouldn't that backup every database of that instance?
>
> In fact, when I look at the list of databases in SQL Management Studio,
I
> see more databases than I am seeing on the backup. It's not just missing
> the 3 databases I restored the other day, I am seeing databases there
that
> I am not seeing in the backup job log.
>
> So: am I just confused, and have forgotten a step somewhere? Why am I
not
> seeing all my databases on the backup job, if I specify just a saveset
of
> "MSSQL:"?
>
> --
> Michael Leone
> Network Administrator, ISM
> Philadelphia Housing Authority
> 2500 Jackson St
> Philadelphia, PA 19145
> Tel: 215-684-4180
> Cell: 215-252-0143
> <mailto:michael.leone AT pha.phila DOT gov>
>
> 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
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
|