Tag: Database Refresh

How to Backup and Restore MongoDB database

In this article, we will see the steps to Backup and Restore MongoDB database. It is important to take regular backups of our system. Backups are good protection against most types of failures.

mongodump tool is used to take backup of MongoDB database or collection or subset of collection.
mongorestore tool is used to restore database or collection on the target database.

mongodump Syntax: 

mongodump [options]

Few options are:

–authenticationDatabase
–db
–username
–password
–out
–host
–uri
–collection
–query
–archive
–oplog
–dumpDbUsersAndRoles
–excludeCollection

MongoDB backup examples:

Continue reading How to Backup and Restore MongoDB database

Sybase Ad-hoc updates to system catalogs not enabled

I have received this when tried to bcp in of the system table ‘sysusers’ in Sybase.

Server Message: LOCALHOST - Msg 10321, Level 14, State 1:
Ad-hoc updates to system catalogs not enabled. A user with System Security Officer (SSO) role must reconfigure system to allow this.

CTLIB Message:  - L1/O3/S0/N14/0/0:
blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results() called.
blk_init failed.
bcp copy in failed

Reason:
This occurs when you try to directly modify an Adaptive Server system table without first using sp_configure to set the allow updates configuration parameter.

Solution: Continue reading Sybase Ad-hoc updates to system catalogs not enabled

Sybase database refresh step by step

In this article, we are going to see step by step procedure of Sybase database refresh.

Steps to perform refresh:

1. Prerequisites.
2. Backup and SCP
3. Load
4. Verification

Source Information:

Source Database Servername: LOCALHOST(Sybase server name)
IP: 192.168.152.130
Source Database name: r2schools

Target Information:

Tartget Database Servername: DEV01(Sybase server name)
IP: 192.168.152.135
Target Database name: r2dev
Continue reading Sybase database refresh step by step