Solved

Sybase - Backup and restore db into other server

Posted on 2014-04-15
1
575 Views
Last Modified: 2014-05-13
Hi guys,

I'm on my plan to do backup of sybase 15.0 from Solaris and restore it on Linux Centos machine.

Beside having the backups  of the db which is around 100GB data size, I'm thinking as well to copy all users from current server and create it in new Linux machine, ut I have no idea how to copy login and create in new sybase.

Upon restored the db, I need to run the statistic and checkstorage, please let me know the command of doing that.

Any recommendation what are the require for me t complete this database migration
0
Comment
Question by:motioneye
1 Comment
 
LVL 13

Accepted Solution

by:
alpmoon earned 500 total points
ID: 40003106
I am sorry for telling that, but it is not just a simple dump and load. There are certain steps you need to achieve that migration.

First of all you need to set database in single user mode, run sp_flushstats and wait for pages to be flushed (it is better to run a checkpoint as well) before dumping the database.  Otherwise it cannot be loaded into a Linux server. Also load will take 2-3 times longer due to conversion and reindex. Even after that you may need to drop and recreate some indexes. Actually they all depend on whether your Solaris is on an intell machine or not.

Check that document before doing anything: http://www.sybase.com/content/1033627/18XPDL_1253_WP.pdf

You can bcp out syslogins and load it into your Linux ASE server. But be very careful, don't include system logins (sa, probe etc.) and don't delete them in target server. Don't try it if you do not feel comfortable with syslogins.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
AWS Central Authentication 1 87
lunix and unix command 21 86
LogmeIn using Linux Ubuntu 16.04 6 63
Remove Resilio directory from Netgear ReadyNAS 212 via SSH. 2 47
Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
Fine Tune your automatic Updates for Ubuntu / Debian
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

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