October 7, 2011 at 8:27 am
Dear Sirs,
My database size is reached up to 1.24GB, Normally we transfer database through FTP server monthly basis, but now it is taking lot of time to upload from one location to other. I locked Transaction log file up to 2MB. But still we need to seperate the database...
for ex: DB1- 01-Nov-2003 - 31-Dec-2009
DB2- 01-Jan-2010 - current date
Here I need to import my 2009 closing balance as 2010 opening balance into the trasaction table(tbltransdetail), but in transaction table we created fields like issqty, recqty but there is no field for opening balance for tht we normally do sum(reciept-issue) as closing balance. But now I need to import or update this closing balance as opening balace into the recqty field but this field has contains daily tranasfer quantity details. How can I bring 31-12-2009 Closing balance as opening balance of 01-01-2010. Please help me in this issue...
Here is my update query:
update tbltransdetail set recqty=a.opening from tblopbal a, tbltransdetail b, tbltrans c
where a.itemfk=b.itemfk and a.itemstatus=b.itemstatus and b.transheadfk = c.pk and a.sublocfk=c.sublocfk and c.doctype='R'
Thanks,
Nirmal Kumar K
October 7, 2011 at 8:30 am
Don't waste time with this. It takes 1 minute to zip a 1 GB file. That'll buy you another couple years before having to waste time on that.
Plan B would be to setup log shipping.
October 7, 2011 at 8:39 am
Actually We compress it using 7-zip after that it becomes 76MB file then we transfer to other location now management needs to seperate the database, becuase of network problem most of the time it is faling to upload this size. If you have any idea about high rate data compression software please let me know.
October 7, 2011 at 8:43 am
ninnumca82 (10/7/2011)
Actually We compress it using 7-zip after that it becomes 76MB file then we transfer to other location now management needs to seperate the database, becuase of network problem most of the time it is faling to upload this size. If you have any idea about high rate data compression software please let me know.
Can't upload 76 MB via FTP???
This is a netowrk problem, nothing to do with SQL.
October 7, 2011 at 8:49 am
You can try taking compressed backup and see the backup size. However, as said, the problem is of network. Get that fixed and get the network pipe size increased.
October 7, 2011 at 8:52 am
cindyaz (10/7/2011)
You can try taking compressed backup and see the backup size. However, as said, the problem is of network. Get that fixed and get the network pipe size increased.
Yes but it takes 2008 Enterprise+ or R2 standard+ & he says sql 2000 in the OP.
The backup size should be fairly close to whatever a good compression software will do. Last I checked I could squeeze another few % after the native backup compress. But I wouldn't waste my time with double compression on this one.
October 7, 2011 at 9:34 am
hah. i saw the forum which is SQL Server 2008 🙂 Forgot op is using SQL Server 2000 while replying!
October 7, 2011 at 10:07 am
Thanks
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply