Contact us


All times are UTC - 8 hours



   [ 6 posts ] 
Author Message
User avatar
   


Joined: Thu Jul 08, 2010 1:39 pm
Posts: 72
I recently Added,Moved, and Delete a bunch of projects to/from SourceAnywhere. This process expanded my .MDF quite a bit.

I'd like to shrink it back down so my backups (etc) don't take so long.

Do you have any procedures to run that would clean up the SourceAnywhere database before I run the SQLServer Packs.


   


Joined: Tue Mar 08, 2005 12:23 am
Posts: 1315
Hi isgdre,

There are two levels of deletion in SourceAnywhere Standalone: Delete and Destroy Permanently.You can purge your deleted files to release more database space. Detailed info can be found here.

Also, you can use the Shrink function in SQL Server Management Studio to shrink SourceAnywhere database. More info:
http://technet.microsoft.com/en-us/libr ... 89035.aspx

Best Regards.

_________________
Catherine Sea
Dynamsoft Support Team
Follow us@Twitter, Facebook


User avatar
   


Joined: Thu Jul 08, 2010 1:39 pm
Posts: 72
Ok, Thanks.

I did do the Destroy Permanently on the big projects I deleted. But with thousands of sub projects I was hoping to not have to go through them one by one.

I mean of course I'm not going to. was just hoping for a better way.

Thanks again.


   


Joined: Tue Mar 08, 2005 12:23 am
Posts: 1315
Hi isgdre,

Quote:
But with thousands of sub projects I was hoping to not have to go through them one by one
You can use SourceAnywhere Standalone SDK to purge the deleted items automatically. Below are the download links:
COM SDK V3.0
Java SDK V3.0

Here is the steps for your reference:
1. Use the ISAWSDeletedItemGeneralInfo Interface to get the ItemName of your deleted item.
2. Use the full name of deleted item (i.e. ItemName) you get plus the PurgeItems Method, you can write a procedure to purge all the deleted items.

Detailed info can be found in the help document of SourceAnywhere Standalone SDK.

Best Regards.

_________________
Catherine Sea
Dynamsoft Support Team
Follow us@Twitter, Facebook


User avatar
   


Joined: Thu Jul 08, 2010 1:39 pm
Posts: 72
Thanks.

Already downloaded the sdk.


   


Joined: Tue Mar 08, 2005 12:23 am
Posts: 1315
You are welcome :)

_________________
Catherine Sea
Dynamsoft Support Team
Follow us@Twitter, Facebook


Display posts from previous:  Sort by  
   [ 6 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
cron
Copyright © 2016 Dynamsoft | All Rights Reserved
dynamic designed by Dynamsoft team
Fatal: Not able to open ./cache/data_global.php