If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > New Members & Introductions > How to backup to tape

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-11-11, 05:58
Bemoo Bemoo is offline
Registered User
 
Join Date: Aug 2011
Posts: 1
Unhappy How to backup to tape - update (anyone?)!

Update;
I have a feeling I have to make a DB-dump (export?) in all cases first and write the dump to tape.
Is this correct? And if so, can onyone tell me how to schedule a dump-job (every office day some time before Tape-job)?
And do I just have to write the dump to tape or more files?

---
I'm no database-expert but use db's for cms's.

I have one server running Windows 2000 with MS SQL-server 2000 and a server running Windows 2008r2 with MS SQL-server 2005 and MySQL.

I'm looking for an easy way to backup the DB's to a tape-devices.

I now have set timed scripts to shut down the DB's one minute before Backup-time (and start DB's after Backup-routine).

Is this a good/safe method?

If I do a quick copy-paste test, the MySQL database is back running quickly (even without shutting down DB before copy) but it doesn't work for MS-SQL DB's (and restore doesn't work).
And I wonder if things go down all together and I have to install everything again, can I restore the MySQL database this way (I mean with a fresh MySQL-setup).

Last edited by Bemoo; 08-17-11 at 03:28. Reason: Update and no response yet
Reply With Quote
Reply

Tags
backup, tape

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On