Reply To: Disk Info issue 2015-03-16T11:13:18+00:00

Home Forums Help needed Disk Info issue Reply To: Disk Info issue

Post count: 100

Sorry for the delay.

When the partition size changes, you need to run the following script.

Suppose partition with volume serial number 0CED08AF has changed size from 451577638912 to 278768590848. Then, the script to run in Sql Management Studio is:

use tabbles;

update [file]
set diskId = '§0CED08AF§278768590848'
where diskId = '§0CED08AF§451577638912';

Of course you need to find the three values (volume serial number, old size , and new size). You can discover volume serial number and new size by right clicking the disk in tabbles, then

folder menu > advanced > “see which disk contains this file”

you can discover the old size by right clicking a file with the “unplugged” icon, and then

advanced > “see which disk contains this file”

Important: Backup your tabbles.mdf file first!

We use technology (including cookies) to collect, use and transfer information to support this Site, including for data analytics purposes, as described in this Site's updated Privacy Policy. Your continued use of the Site signifies your acceptance of such cookies. To learn more about how to manage your cookie settings and how to exercise your rights under GDPR please see our Privacy Policy

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.