Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-08-18
4
Medium Priority
?
211 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

Technology Partners: 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

I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
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 tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
Suggested Courses

636 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