Hello all,

Apologies in advance for the OT message. I'm in a small bind.

SQL Server 2k on a shared host.

My hosted DB's allowed disk space is full and I need to add an index
('primary filegroup is full').  I've backed up and truncated the transaction
log and have a complete copy of the DB in case anything goes wrong.

Is there any way to drop or delete backup files without having SA or equiv.
access?  If so, would this restore space to the primary filegroup, or does
this depend on how the hosting company has configured SQL Server?  I'v read
about expiring backups but can't seem to find the options in Enterprise
Manager.

Any help is greatly appreciated!

Jeff
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation � $99/Month � Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to