• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Problems with Tapeware SQL backup via ODBC (Version 7 SP5c)

We have W2k3 SBS with Tapeware 7 SP5c and are trying to configure the SQL agent, without success!!

We can only get LocalServer to show in the Backup Selection dialogue box, but when that is expanded it doesn't show any databases!

I have followed the instructions for defining the databases in ODBC and restarted the services and used the correct username (sa) etc etc but still nothing!!

Yosemite support just tell me it can't be configured right!

Has anyone managed to get this version to work - if so some tips would be VERY welcome.

Note: I have replicated the setup on W2K SBS with the same (lack of!) results.

Mark
0
markfullarton
Asked:
markfullarton
1 Solution
 
Cyber-DudeCommented:
Try to update service packs (SQL SPs may solve lots of problems). Also, verify what the event viewer has to say about that matter. Next, try to visit the following MS article about resolving some SQL issues... Please inform us with further details:
http://support.microsoft.com/default.aspx?scid=kb;en-us;827422&Product=sql

Cyber
0
 
markfullartonAuthor Commented:
Thanks for the reply Cyber

I have already ensured that all service packs are in place, I shoudl have mentioned it!

I have now managed to work out what is going wrong, or rather how to get things working!

I was lead to believe that the SQL databases should be visable when the SQL agent was selected, I assumed so you could select which databases you want to backup. However it woudl appear that you have to select the SQL server instance as a whole to back-up. When you have done this once the databases appear in the selection dialogue!!

It seems that you also need to set an ODBC source name of LocalServer, despite the tapeware documentation saying the you should use localhost.

These issues, plus the fact that the TWTRACE file was telling me that it couldn't open the SQL databases threw me somewhat!!

Still, all's well that end's well - I suppose.

Case Closed (I think!!!!)

Mark

0
 
Computer101Commented:
PAQed, with points refunded (500)

Computer101
E-E Admin
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now