Problem creating a database

• K-Nine

  SSC Rookie

  Points: 45

  More actions

  January 10, 2007 at 1:07 pm

  #171748

  i am getting a strange Issue when I try to create a database,  The Trans Log will not set to unlimited Growth!!!!!!!

  I can try to manually set it with SQL, or with the Management Studio.   It just will not set to unlimited growth

   

  When I run the follow script:

  CREATE DATABASE myDatabase

  ON

  ( NAME = 'myDatabase_Data',

    FILENAME = 'D:\Program Files\Microsoft SQL Server\data\myDatabase_Data.mdf',

    SIZE = 10MB,

    MAXSIZE = UNLIMITED,

    FILEGROWTH = 10% )

  LOG ON

  ( NAME = 'myDatabase_Log',

    FILENAME = 'D:\Program Files\Microsoft SQL Server\Data\myDatabase_Log.ldf',

    SIZE = 5MB,

    MAXSIZE = UNLIMITED,

    FILEGROWTH = 10% )

  GO

  Then when I check the properties:

  CREATE DATABASE [myDatabase] ON  PRIMARY

  ( NAME = N'myDatabase_Data', FILENAME = N'D:\Program Files\Microsoft SQL Server\data\myDatabase_Data.mdf' , SIZE = 10240KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)

   LOG ON

  ( NAME = N'myDatabase_Log', FILENAME = N'D:\Program Files\Microsoft SQL Server\Data\myDatabase_Log.ldf' , SIZE = 5120KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

   COLLATE SQL_Latin1_General_CP1_CI_AS

  GO

   

   

  Thanks,

  Dan

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  January 10, 2007 at 1:15 pm

  #682544

  What Edition are you using? What version?

  Run this:

  SELECT ServerProperty('Edition'),

  ServerProperty('ProductLevel'),

  ServerProperty('ProductVersion')

  -SQLBill

• K-Nine

  SSC Rookie

  Points: 45

  More actions

  January 10, 2007 at 1:18 pm

  #682546

  hey SQLBill,

   

  Standard Edition (64-bit)

   SP1 9.00.2047.00

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 10, 2007 at 1:52 pm

  #682553

  http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/7f80428fbc46c8eb/ef03601f6db6487d?lnk=st&q=sql+server+2005+log+file+maxsize+issue&rnum=1&hl=en#ef03601f6db6487d

   

  MohammedU
  Microsoft SQL Server MVP