2 databases (sql server 7) have been created in same conditions : same tools "bcp..." and same options.
On both 2 series of "users tests" have been executed. These tests were exactly the same !
At the end we have executed a "backup" procedure on each database.
We expected the same size for the two backup database but we obtained two different results :
304,56Mo and 302,81Mo for databases, 10,64Mo and 11,34Mo for the log transaction.
Could you help us explaining this difference of almost 2 Mo ?I wouldn't worry about that small size difference in backup. Are the tsql SQL Server of the same
service pack? Also, do you do *exactly* the same for the two, all the way since the database
creation. If you want to pursuit this (I wouldn't), then I recommend that you have a scrip file
which includes the CREATE DATABASE command to exclude as much "noise" as possible,
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Laurent L. (France)" <llechat@.sodifrance.fr> wrote in message
news:649E6E72-A43F-4084-88BB-48ACDF8AECC1@.microsoft.com...
> 2 databases (sql server 7) have been created in same conditions : same tools "bcp..." and same
options.
> On both 2 series of "users tests" have been executed. These tests were exactly the same !
> At the end we have executed a "backup" procedure on each database.
> We expected the same size for the two backup database but we obtained two different results :
> 304,56Mo and 302,81Mo for databases, 10,64Mo and 11,34Mo for the log transaction.
> Could you help us explaining this difference of almost 2 Mo ?
No comments:
Post a Comment