Solved

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

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

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.
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
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…

839 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