[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Sybase - Backup and restore db into other server

Posted on 2014-04-15
1
Medium Priority
?
667 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 2000 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Often times it's very very easy to extend a volume on a Linux instance in AWS, but impossible to shrink it. I wanted to contribute to the experts-exchange community a way of providing a procedure that works on an AWS instance. It can also be used on…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.
Suggested Courses
Course of the Month20 days, 4 hours left to enroll

872 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