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