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

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

Maurizio
Keymaster
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!

By continuing to use the site, you agree to the use of cookies. more information

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.

Close