Solved

Sybase - Backup and restore db into other server

Posted on 2014-04-15
1
584 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
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.

761 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