|
If I'm not mistaken the "WHATSUP" is your SQL Server
instance. Basically, you can run multiple instances of SQL Server on the
same box but for security reasons make them separate from an application
perspective. Most SQL is installed with the "Default" instance, but
occasionally some new guy will hit the radio button during install for a
non-default instance and hose everything up for everyone else who isn't a MS SQL
guru by naming it something retarded like "WHATSUP". The best way to tell
if you are running multiple instances is probably to check the Services.
Generally there will be a SQL Server (INSTANCE NAME) entry for each
instance. Its probably too much to ask to reinstall SQL at this point if
they are not using instances, so you are just going to have to specify the
server name and instance whenever connecting to this box. Documentation of
configuring MSSQL backups can be found here.
If you are running multiple instances you will have to use
the MS SQL Client piece to put in the SA password for each of the
instances. You might be able to create a .Bch file for each instance and
then merge them into a single .bch file so you can get "one full" for that
server, but I've never tried it. Alternately, just add each script as a
separate selection under the selection list.
Good luck!
-Jonathan
UNCLASSIFIED
I don't know a great
deal about MSSQL so bear with me. I think the answer to this might actually be
out of an MSSQL book rather than Netbackup but hopefully someone may be able to
shed some light on this.
I've successfully
backed-up a MSSQL DB before and effectively copied the working policy and
changed a few things (copied the working .bch file to the new SQL server and
updated policy to point to this new file).
When I ran the
backup, it exited with status 2. I then logged onto the SQL server in question
and ran NetBackup MS SQL Client config, where it asked me to configure. I put
the host in and it was having problems. Eventually I looked at OBDC and looked
at SQL DBs and noticed the DB was listed as server SQLSERVER\WHATSUP (I've
called the host SQLSERVER in this email rather than the actual hostname). I then
modified the .bch file and renamed host entry to SQLSERVER\WHATSUP and now it's
working.
My question is will
this be backing-up the databases I need to backup (is there any way to verify
this easily?)? Why did I need to specify SQLSERVER\WHATSUP rather than just the
hostname of the server (previously I've only had to specify actual hostname of
server)? I'd guess most of this is due to the way it was setup (which was done
by someone else) but I'm really trying to understand how Netbackup connects with
SQL and to make sure I haven't missed any DBs with the way I've configured
this.
Cheers,
---------------------------------------------------------------------
Tim Wilkinson
I.T. Support Officer
Science Corporate
Information Systems
Defence Science &
Technology Organisation
Department of
Defence
Tel: (02) 93810065
Fax: (02) 93810011
Email: tim.wilkinson AT dsto.defence.gov DOT au
IMPORTANT: This
email remains the property of the Australian Defence Organisation and is subject
to the jurisdiction of section 70 of the Crimes Act 1914. If you have received
this email in error, you are requested to contact the sender and delete the
email.
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
| 