Empty data files completely?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Zarko Jovanovic (RmEaMkOnViEoTHvIoSmind_less_at_bigfoot.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 12:32:04 +0200

 Hi,

Is there a way to completely empty some data files in the same filegroup so
I can delete them?

thanx 

-- 
--
remove RmEaMkOnViEoTHvIoS from my email
svi komentari i razmisljanja su moja kao pojedinca i nikako se ne smiju
povezivati sa tvrtkom u kojoj radim

Relevant Pages

  • Re: Disk Queue Length counters not meaningful in SQL 2000?
    ... use RAID 10 for everything. ... able to get buy with RAID 5 for data files, RAID 10 for log files, and RAID ... BulkInOut1 - One data File on the E drive. ... Non-Clustered Indexes Created on Primary filegroup - 66 The following tests added the Index filegroup with different file placement. ...
    (microsoft.public.sqlserver.server)
  • Re: Suggestions for managing large tables
    ... data files are contained within a filegroup and filegroups are ... secondary data file on that new LUN. ... other than PRIMARY) containing a data file on the new disk and then move ...
    (microsoft.public.sqlserver.server)
  • Re: Java XML document creation
    ... this notation so far as I know is something you cooked up, and empty ... data files are not something there is a big demand for. ...
    (comp.lang.java.programmer)
  • Re: Duplicate Contact Folders
    ... Tools> Account Settings> Data Files ... as the default in your profile, restart Outlook, then close the empty one. ... At that point you should be able to display your Contacts Folder in the ... > 'Contacts in Personal Folders'. ...
    (microsoft.public.outlook.contacts)
  • Re: SQL Server 2005 - filegroup backup/restore problem
    ... I still have a problem of empty table after last backup/restore+recovery. ... now I can recover the database and make it online. ... Say that there is a SalesOrder table which is in the Primary group. ... If the filegroup would be available after the filegroup restore, ...
    (comp.databases.ms-sqlserver)