Networker

Re: [Networker] Backup of SQL client

2008-01-29 11:05:41
Subject: Re: [Networker] Backup of SQL client
From: Kevin Malone <kcmalone AT SALISBURY DOT EDU>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Tue, 29 Jan 2008 11:01:57 -0500
All the databases are under the default instance.  There are no other instances 
on the server other than the default instance.  It is SQL 2005.

>>> "Rohrich, James" <James.Rohrich AT UOP DOT COM> 1/29/2008 10:42 AM >>>
You may run more than one instance of SQL on a server each of which may
have multiple databases. Is there more than one instance of SQL running
on that server? The backup of multiple instances is documented in the
manual. MSSQL will not pick up multiple instances, but remember an
instance is not the same as a database. 

James Rohrich
 
Enterprise Data Architect
IT Planning
UOP LLC
25 E. Algonquin Rd.
Des Plaines, Illinois 60016
Tel: (847) 391-3958
james.rohrich AT uop DOT com 
www.UOP.COM 
 
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Kevin Malone
Sent: Tuesday, January 29, 2008 9:00 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU 
Subject: [Networker] Backup of SQL client

A great suggestion that was given to me back up ALL SQL databases on a
client without having to list each save set seems to be working
perfectly (putting MSSQL: in the save set of the client).  One question
I have about this for those who do it....  this is what I am seeing on
the savegroup reports that are e-mailed to me by this client.  I am
curious why it is surpressing the output.  Any insight on this?  Just
curious why it will not show the results for all the databases for this
client.

Using Networker 7.2.2 jumbo on the server and version 5.0 of the SQL
client.

 provo:MSSQL: savegrp: suppressed 36 lines of output - 
check daemon.log for details.
* provo:MSSQL: 
* provo:MSSQL: 
* provo:MSSQL: [4184] [S]  01/28/08 21:04:34 Backing up of ePO_LANSING
succeeded.
* provo:MSSQL: 
* provo:MSSQL: 
* provo:MSSQL: [4184] [S]  01/28/08 21:04:35 Backing up of master
succeeded.
* provo:MSSQL: 
* provo:MSSQL: 
* provo:MSSQL: [4184] [S]  01/28/08 21:04:36 Backing up of model
succeeded.
* provo:MSSQL: 
* provo:MSSQL: 
* provo:MSSQL: [4184] [S]  01/28/08 21:04:36 Backing up of msdb
succeeded.
* provo:MSSQL: 
* provo:MSSQL: 
* provo:MSSQL: [4184] [S]  01/28/08 21:05:10 Backing up of webcttestdb
succeeded.
* provo:MSSQL: 
* provo:MSSQL: 
* provo:MSSQL: [4184] [S]  01/28/08 21:05:12 Backing up of
webcttestdb$PF succeeded.
* provo:MSSQL: 
* provo:MSSQL: 
  provo: MSSQL:                   level=1,       983 MB 00:04:58     18
file(s)
* provo:MSSQL: [4184] [I]  01/28/08 21:05:12 Skip building named
instance directory because there are no named instances installed or
running on this machine.
  houston.salisbury.edu: index:provo level=5,      270 KB 00:00:50
183 files


Kevin Malone
Network Administrator
Salisbury University
Information Technology  FH297
kcmalone AT salisbury DOT edu 
410-543-6298

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

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>