Database

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..

Advertisements

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 …