EM uses 20+MB of space to create 2MB of scripts?

• J Bagwell

  Mr or Mrs. 500

  Points: 514

  More actions

  May 18, 2005 at 12:39 pm

  #102536

  I'm trying to script out all of my database objects. I'm using EM, Generate SQL Script, Script all objects, Script database, database users, databse roles, SQL Server logins, object-level permissions, indexes, and Primary/Foreign keys.  Each to its own file.

  When this process is complete, I have 2.18 MB of scripts in my folder.

  However, if I run this (EM, Generate SQL Script, etc) and try to save these files to a drive that only has 20 MG of free space, I run out of space before the process is complete. 

  How come creating 2.18 MB of scripts takes up more than 20 MB in the process?

  Thanks to anyone who can shed light on this for me.

  Jana

  ---

  J. Bagwell

  UVA Health System
  

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  May 31, 2005 at 12:22 pm

  #561986

  I do not believe that it is the EM at fault. It's the OS. You're probably a victem of disk fragmentation.

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."