Fail to Create New Database

• Roji V George-301437

  Newbie

  Points: 9

  More actions

  February 11, 2006 at 1:06 am

  #113302

  When i try to careate new databse i am getting an error message something like....

  Error 945 : Database 'cc' cannot be opened due to inaccessible files or insufficient memory or disk space

  See SQL Server Error log for details

  The CREARE DATABASE process is allocating 1.00 MB on disk 'cc_data'

  The CREARE DATABASE process is allocating 1.00 MB on disk 'cc_log'

  Device activation error. The physical file name '\\Comp1\it\_log.LDF' may be incorrect.

   

  i never give the following path or file name anywhere .... i dont know from where it is coming...... '\\Comp1\it\_log.LDF' !!!!!!!!!!!!

   

  Thanks

   

  Roji

• Jen-169507

  Right there with Babe

  Points: 776

  More actions

  February 12, 2006 at 8:48 pm

  #620355

  1. CREATE command wrong

  2. check for available disk space on the drives mentioned

  3. are you creating the database remotely? like over a SAN?

  4. the path is a default one, ask your DBA about it

   

  HTH