Re: copy DB1->DB2 with DTS - Databasesize is different, why?

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 19:54:03 +0100

Then I wouldn't fret. If it looks OK, plays OK and nothing says it isn't OK
I would make the assumption it is OK. 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"KE" <KE@discussions.microsoft.com> wrote in message
news:87006AA4-2B1F-43D8-99E6-CEBBD8AD01BC@microsoft.com...
> Hi Allan,
>
> I have the same assumption as you,  but that the new database size is just
> 75% of the orginal one surprised me. The data rows are equal and the
> application seems to run smoothly - so far.
>
> Best regards,
> KE
>
> "Allan Mitchell" wrote:
>
> > Fragmentation?  Less free Space?
> >
> > In a database where you have reentered all the data it will be nice and
> > tight whereas a database over time will fragment, the log will expand,
the
> > data files will expand etc tec
> >
> > -- 
> > -- 
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.SQLDTS.com - The site for all your DTS needs.
> > www.konesans.com - Consultancy from the people who know
> >
> >
> > "KE" <KE@discussions.microsoft.com> wrote in message
> > news:FB267372-3D10-4599-80EE-719615C91CBE@microsoft.com...
> > > Hi all,
> > >
> > > My intention is to move a database on  a new database server. I
created a
> > > database script on the source and started that script on the new
server.
> > The
> > > new database structure looks fine. Then I exported all data from the
> > source
> > > server to the new one via DTS. I checked several tables and the number
of
> > > rows are equal, but the size of the whole new database is about 25%
> > smaller
> > > (MB) than the source database. Why that?
> > >
> > > Thanks for your feedback.
> > >
> > > Best regards,
> > > KE
> >
> >
> >

Relevant Pages

  • Re: Running DTS Package
    ... The name i give to my package is: ... "Allan Mitchell" wrote in message ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Help Restoring Database
    ... Studio Express to make a backup of the MSDE 2000 databases. ... the mdf or ldf files to a new database using SQL Management Studio Express ... Microsoft SQL Server Management Studio Express ...
    (microsoft.public.sqlserver.msde)
  • RE: Using Access with concurrent users
    ... > See way below, at end of this stuff, for getting a user's network login ... > If you are optimizing the performance of an Access database, ... > to start is with the Performance Analyzer. ... > that connects to a Microsoft SQL Server database and is used to create ...
    (microsoft.public.access.setupconfig)
  • RE: Using Access with concurrent users
    ... See way below, at end of this stuff, for getting a user's network login ... If you are optimizing the performance of an Access database, ... The Performance Analyzer can also make some proposed changes for you if you ... Microsoft SQL Server database and is used to create client/server ...
    (microsoft.public.access.setupconfig)
  • RE: SMS_INVENTORY_DATA_LOADER Error
    ... Microsoft SQL Server reported SQL message 547, ... statement conflicted with TABLE REFERENCE constraint 'DataItemContext_1_FK'. ... The conflict occurred in database 'SMS_100', ... Rolling back policy transaction due to error. ...
    (microsoft.public.sms.inventory)
Quantcast