Information générale
Forum:
Microsoft SQL Server
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement