Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009

    Unanswered: Sybase database craetion error

    Hi All,
    I am new to sybase ,when I am trying to create a new databse with the command
    1> create database unittest
    2> go
    CREATE DATABASE: allocating 256 logical pages (0.5 megabytes) on disk 'master'.
    Msg 1810, Level 16, State 1:
    Server 'xxxx2110', Line 1:
    CREATE DATABASE failed because of incorrectly specified or unavailable space.
    Total number of megabytes specified and available must be at least 3 megabytes
    so Model Database can be copied to the new database.

    Can anybody help me out to solve this?

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    The model database is used as the base for a new database
    As the error message say, your new database must be at least 3 MB in size

  3. #3
    Join Date
    Jun 2009
    Thanks a lot.

  4. #4
    Join Date
    Apr 2008
    Hi ,
    Adding to the above if u are not mentioning size in create database command thn it will take the value as set from config parameter "default data size".So check wht is the value set . ya it should be greater than the size for model database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts