Re: consolidating two data files into one.

From: Dan D. (DanD_at_discussions.microsoft.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 08:23:03 -0700

Thanks Wayne.

"Wayne Snyder" wrote:

> Kick people out of the database
> do a dbcc shrinkfile emptyfile on the one going away ( that moves data into
> the other file)
> then alter database prod drop file file2
>
> Backup everything first.
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Dan D." <DanD@discussions.microsoft.com> wrote in message
> news:6A3DC97A-CBA1-496D-A1D7-2E7CB0B39837@microsoft.com...
> > Using SS2000. We have a database that has two data files of the same name
> but
> > in different folders. I want to move the database to a different drive. Is
> > there a way to combine the two data files into one?
> >
> > Thanks,
> > --
> > Dan D.
>
>
>

Relevant Pages

  • Re: Time range matching
    ... > datetime with a time range that spans multiple days... ... > Wayne Snyder, MCDBA, SQL Server MVP ... > community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
  • Re: Add new column to a replicated table..
    ... "Wayne Snyder" wrote in message ... > Sp adds the column to the table, and fixes replication... ... > Wayne Snyder, MCDBA, SQL Server MVP ... > community of SQL Server professionals. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to know the table size in sql database and how to know whi
    ... each table during the iteration that happens within the stored procedure. ... > Wayne Snyder, MCDBA, SQL Server MVP ... > community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
  • Re: How to learn .Net
    ... > Wayne Snyder, MCDBA, SQL Server MVP ... > Mariner, Charlotte, NC ... >> I read everywhere at the moment that SQL Server professionals need to ...
    (microsoft.public.sqlserver.server)
  • Re: VARCHAR to INT
    ... ISNumeric function allows float, decimal numbers also... ... > Wayne Snyder, MCDBA, SQL Server MVP ... > community of SQL Server professionals. ...
    (microsoft.public.sqlserver.programming)
Loading