Jason Zander
06-22-2009, 11:51 AM
If your database size is growing and reaching the 2GB cap (For MSDE, the standard SQL Database installed with liberty), you may have heard a support technician mention a data repack.
As per our pricing webpage, here is the cost for a repack:
Database Repack (includes SQL SP4 update) $100.00 ($150 if not on a Support Plan)
Prices can be found on the following website: http://resaleworld.com/products.php?group=9
We use Data Transformation Services (DTS) from the MSSQL package to copy the data from one database.
There are plenty of websites that show how to use DTS and various tips and tricks. If you are wanting to attempt the repack on your own, please utilize those resources for further information and consult a certified Database Admin. Resaleworld will not be able to assist in any repacks you are attempting on your own, nor can we fix any issues that go wrong after attempting one on your own. Always have a backup of your data in a safe location prior to the repack should something not work and you need to revert back.
Also, after repacking, be sure to update to SP4 for your MSSQL server.
http://forums.resaleworld.com/showthread.php?t=2243
As per our pricing webpage, here is the cost for a repack:
Database Repack (includes SQL SP4 update) $100.00 ($150 if not on a Support Plan)
Prices can be found on the following website: http://resaleworld.com/products.php?group=9
We use Data Transformation Services (DTS) from the MSSQL package to copy the data from one database.
There are plenty of websites that show how to use DTS and various tips and tricks. If you are wanting to attempt the repack on your own, please utilize those resources for further information and consult a certified Database Admin. Resaleworld will not be able to assist in any repacks you are attempting on your own, nor can we fix any issues that go wrong after attempting one on your own. Always have a backup of your data in a safe location prior to the repack should something not work and you need to revert back.
Also, after repacking, be sure to update to SP4 for your MSSQL server.
http://forums.resaleworld.com/showthread.php?t=2243