Solved

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

Posted on 2004-08-18
4
206 Views
Last Modified: 2010-04-03
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
Comment
Question by:markfullarton
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 15

Expert Comment

by:Cyber-Dude
ID: 11828995
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
 

Author Comment

by:markfullarton
ID: 11838915
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12251934
PAQed, with points refunded (500)

Computer101
E-E Admin
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lets start to have a small explanation what is VAAI(vStorage API for Array Integration ) and what are the benefits using it. VAAI is an API framework in VMware that enable some Storage tasks. It first presented in ESXi 4.1, but only after 5.x sup…
Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question