>I have a question about the space usage on SQL server 6.5. I have 2 databases on 2 different servers which are 13 gigs each. I transfered the production side database over to the back up database. The tranfer completed successfully; however I am getting space useage issues:
>11,965.98 is used space on BACK UP DATABASE
> 1,034.02 is free space on BACK UP DATABASE
>
>8,377.67 is used space on production database
>4,622.33 is free space on production database
>
>any suggestion(s) or comment(s) is appreciated.
>Sal

Hi,

Does it include the transaction log, if yes, try to dump the transaction with the command :

DUMP TRANSACTION "database" to DISKDUMP WITH NO_LOG.

This will empty the transaction log. I think this is why you have a big difference in the used/free space.