开发者

SQL Server database + strange things

I have 3 instance of database named X.开发者_如何学Python Each of them is on the other server. Now... Let's look on the some table named Orders.

  • In X_1 and X_2 size of this table is about 500MB with 1 000 000 records.
  • In X_3 size of this table is about 1,5 GB with 1 000 000 records.

Why? What is wrong. I have made shrink on each database.

I'm confused :-)!


are there any configuration differences in the data bases? If not there, then check for differences in file systems (such as block size, device architecture, etc).


look and see if what recovery mode each database is in (right-click database, properties, options). i'm betting that the third database is in full recovery mode and the other two are in simple.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜