OldSkoolSkater
MIS
Hi all
I would like to take a copy of a live database to enable me to test with it.
I have created a test DB and used the DTS import wizard to copy data into it, but when I look at the DB size in Enterprise Manager it is smaller than the source DB from which information has been taken:
The source DB is showing as 219MB with 15Mb of free space.
The new DB is showing as 190MB with 18MB of free space.
Is this because the import process has filtered out all the unused space, etc. from the source and streamlined it for the destination?
Or am I guessing wildly??
Cheers
Steve
I would like to take a copy of a live database to enable me to test with it.
I have created a test DB and used the DTS import wizard to copy data into it, but when I look at the DB size in Enterprise Manager it is smaller than the source DB from which information has been taken:
The source DB is showing as 219MB with 15Mb of free space.
The new DB is showing as 190MB with 18MB of free space.
Is this because the import process has filtered out all the unused space, etc. from the source and streamlined it for the destination?
Or am I guessing wildly??
Cheers
Steve