Sybase database create on a device, which means you have to create a device first with a proper size before creating a database.
In my previous post I navigate through the steps of creating Sybase ASE device, database, dump and load using command. In this post I will guide you through the steps using Sybase Central ‘GUI‘ instead of CLI
I will cover:
Sybase Adaptive Server Enterprise (ASE) introduces enhanced dump and load capabilities for moving databases or restoring backups to a different ASE .
It may be confusing for some other database administrators. So, I would like to share with you my experience and give you a brief explanation of the device, database and the restoration of the Sybase database from command line.
Transfer logins and passwords between instances of SQL Server
backup databases and restored it into new instances or database server quite easy, but the challenge is how to move the logins and password?
SQL Server backup Using Management Studio and Transact-SQL
How to create a full database backup in SQL Server 2008 R2 by using SQL Server Management Studio and Transact-SQL, As a database increases in size full database backups take more time to finish and require more storage space. Therefore, for a large database, you might want to supplement a full database backup with a series of differential database backups.