INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Backup

Backup

(OP)
I'm trying to backup an ADP database using SQL Talk. The database name is pay4win and the server name is fred3. This is the script I have in SQL Talk:

connect pay4win user/password;
set server fred3;
use 1;
backup snapshot to c:\backup\pay4win on server;
disconnect pay4win;

I get the following error though: Error: Database name not configured

Does anyone have any idea? I just want to create a script and then create a task to run it every night so the database is backed up.

Thanks,
Ken


RE: Backup

(OP)
Please disregard my previous post as I figured out what was wrong.

RE: Backup

Hi Ken,

I hope you can help me. I am using SQLBase 7 database. I have a PROD database and a DEV database. The data in PROD database is till date.

1.When i try to copy the .dbs file from PROD to DEV, i find that DEV database is not updated. Is there anything else i have to do after copying the .dbs file to DEV from PROD??
2. I took backup snapshot of PROD database. When i try to restore the DEV database from the the PROD SNAPSHOT, the system does not let me. However, when i do the restore from DEV SNAPSHOT, the system does it fine. My aim is to update the DEV database with PROD database.

Thanks in advance.....
Indoaryaan.

RE: Backup

Ken,
What change to your SQLTalk script did you make to get it to work?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close