Database

Administrate Sybase ASE using Sybase Central GUI

Sybase Central

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:

Create ASE Devices, Database and load database

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.

more..

SQL Server backup

SQL Server backup Using Management Studio and Transact-SQL

SQL2008

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.

more …