Even if you have the BE Agent, I think most folks will tell you to just
backup dumps instead. Take it from me. Recovering a Dump is infinitely
easier than recovering a DB with BE.
-----Original Message-----
From: Terence Choy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 6:21 PM
To: NT System Admin Issues
Subject: RE: SQL authentication
I guess do the SQL 7 internal backup to disk and then back up the
back-up files is another way. Since I have BE SQL Agent, I would like
to exploit an alternative to back up the databases. The reason the
standalone SQL 7 computer cannot join the domain is it has an
application, Gentran for NT Server. This is a EDI mapping software from
Sterling Software and it uses MS SQL Server. I have tried to join the
computer to a domain but that cause problems to Gentran. I have talked
to Sterling about this and they advised to run Gentran in a standalone
environment. I created a user, ediadmin, in the domain with the same
username and password in the standalone SQL 7 computer. When I logon
the backup SQL 2000 member server as ediadmin, I am able to attach to
the SQL7 computer in the SQL 2000 Enterprise Manager and perform all
functions to the databases in SQL7. However, I cannot use ediadmin to
attach to MS SQL Server in the BackupExec Selection tab inside the Job
Definition tab. Hence, SQL Agent in BE won't work. BTW, all BE
services and SQL Server service are logon as ediadmin. Any suggestions?
-----Original Message-----
From: Diane Beckham [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 5:22 PM
To: NT System Admin Issues
Subject: RE: SQL authentication
Do you have the SQL Server 7 doing it's own backups internally? If you
do, then you don't need to back up the SQL 7 databases, just backup the
backups.
Can you explain in more detail your statement about not being able to
join the domain because the main application won't work. What
application. If your SQL server is a stand alone server can you add a
user with the same name from the domain as a user on your stand alone
server and give it permission as backup operator?
Diane
-----Original Message-----
From: Terence Choy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 12:34 PM
To: NT System Admin Issues
Subject: SQL authentication
Hi,
I have a MS SQL question and I understand this is not the forum for it,
but I would really appreciate if someone will help here or point me to
the right places! Here is my situation: A standalone NT4 computer
loaded with SQL 7 (can't join the domain because the main application in
this computer won't work). A NT4 member server loaded with Veritas 8.6
and SQL 2000 for backup operation.
I need to backup the SQL 7 databases in the standalone machine by using
the backup member server. The problem is I cannot connect to the SQL 7
databases from the member server. When I tried in the SQL 2000
Enterprise Manager to create a new SQL Server group for the standalone
computer with SQL 7, it failed to connect by either using the Windows NT
authentication or the SQL Server authentication. What do I miss? TIA.
Terence Choy
http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
