Comments
Sort by recent activity
Don't forget to change the CREATE statements to ALTER otherwise any permissions that were granted may be lost.
For some reason, permissions are not generated in the script.
Regards, / comments
Don't forget to change the CREATE statements to ALTER otherwise any permissions that were granted may be lost.
For some reason, permissions are not generated in the script.
Regards,
I have numerous databases in which the schema should be very close to the same, so eliminating the identical items allows me to focus on whether the difference is expected or not. / comments
I have numerous databases in which the schema should be very close to the same, so eliminating the identical items allows me to focus on whether the difference is expected or not.
Thanks. I restarted the sql server. Ran the DBCC and copied the dll unto the server and that seems to have done it.
Larry / comments
Thanks. I restarted the sql server. Ran the DBCC and copied the dll unto the server and that seems to have done it.
Larry
That reply does not make sense. 2008 still has extended stored procedures and your own product SQL Backup continues to use them. / comments
That reply does not make sense. 2008 still has extended stored procedures and your own product SQL Backup continues to use them.
That makes sense, but the reason I ask the first question is because the tables that are the basis for the compare comprise about 25% of the space for the database. So I began to wonder, where this data was being put in respect to the server and or client. The backup file is a compressed SQL Backup file located on a networked file server.
Thanks,
Larry / comments
That makes sense, but the reason I ask the first question is because the tables that are the basis for the compare comprise about 25% of the space for the database. So I began to wonder, where this...
Found it in the installation folder of MultiScript1. In my case, it was "C:Program Files (x86)Red GateSQL Multi Script 1".
Thanks,
Larry / comments
Found it in the installation folder of MultiScript1. In my case, it was "C:Program Files (x86)Red GateSQL Multi Script 1".
Thanks,
Larry
Thank you. / comments
Thank you.
Quick and accurate. Just like your products.
Thanks. / comments
Quick and accurate. Just like your products.
Thanks.
DATABASE DATABASE_SIZE (KB)
Database1 3,651,264
Database2 529,452,608
Database3 691,714,048
Database4 63,744
Database5 2,263,360 / comments
DATABASE DATABASE_SIZE (KB)
Database1 3,651,264
Database2 529,452,608
Database3 691,714,048
Database4 63,744
Database5 2,263,360
It may be somewhat slower on both the backups and the restores, but not even close to what I originally saw.
It does seem to be working at acceptable levels for the time being. / comments
It may be somewhat slower on both the backups and the restores, but not even close to what I originally saw.
It does seem to be working at acceptable levels for the time being.