Re: [Networker] Backup of SQL client
2008-01-29 11:05:41
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
|
|
|