Solved

Sybase - Backup and restore db into other server

Posted on 2014-04-15
1
542 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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction Regular patching is part of a system administrator's tasks. However, many patches require that the system be in single-user mode before they can be installed. A cluster patch in particular can take quite a while to apply if the machine…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now