Solved

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

Posted on 2004-08-18
4
203 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
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

Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
UAT environment 1 55
File copy time stamp question 6 54
NETAPP create a quota on a QTREE 2 11
Windows 2008 Server C Drive too full 25 37
AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
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…

861 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now