Re: MSDE data files

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

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/02/04 

Date: Fri, 02 Apr 2004 09:42:40 -0700

For resizing, check books online and the alter database
statement. You can modify file sizes using alter database.
For compacting, check books online for dbcc shrinkfile. This
reducing the size of a database file.
If the log files are what's causing problems, you should be
backing up the transaction log. If restoring log files is
not part of your recovery plan, you may want to look at
setting the recovery model to simple.

-Sue
 
On Fri, 2 Apr 2004 07:37:08 -0800, "Pete"
<x_Pete_x@yahoo.com> wrote:

>One thing I cannot find answer to..: HOW DO YOU RESIZE /
>COMPACT data file for the MSDE databases??? They
>obviously keep growing fast and fat, gobbling more space
>than necessary.

Relevant Pages

  • Re: Moving DB from one drive to another
    ... In the copy of Books Online I have it suggests ALTER DATABASE SET OFFLINE. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Logical File Names
    ... Look at ALTER DATABASE in Books Online. ... Aaron Bertrand ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Hanging during READ_COMMITTED_SNAPSHOT ON
    ... I realize that all connections expect the query window need to be ... ALTER DATABASE db SET SINGLE_USER WITH ROLLBACK IMMEDIATE ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • RE: Removing rows from very large table with indices
    ... Yes you can put db into single user mode using alter database and termination options like: ... SET SINGLE_USER WITH ROLLBACK AFTER X (See Books Online ..) ... My suggestion is first script your table then create your new table using this script, transfer data, create indexes on new table and so on. ...
    (microsoft.public.sqlserver.server)
  • Re: tempdb file creation error
    ... I'd have to look it up but I'm pretty sure data and log files can have ... Essentially tempdb is generated with a CREATE ... DATABASE at startup - where is this stored? ... or perhaps ALTER DATABASE MODIFY or ADD FILE will ...
    (microsoft.public.sqlserver.server)