January 3, 2010 at 11:20 pm
Hi,
I got thru the following problem.
I have some lacs of records in one server (say serverA). while copying the records from one server A to another server B, after copying some records server B is running out of disk space. In this case, if we remove the temp data then the operation would be successful?
If Yes please provide me the details how to do it and what query to run against the database.
If not please provide me the solution.
Please assist me to resolve the issue.
Thank you,
Venu Babu
January 4, 2010 at 12:17 am
More information needed
January 5, 2010 at 3:21 am
Unless you have a huge amount of temporary data, you need to add disks to the second server. I've never seen a situation where the temporary data was large enough to make a difference.
January 6, 2010 at 9:32 am
1) what is this "temporary data" you are removing?
2) what error messages are you getting?
3) is auto growth on and what it the setting?
4) how much free space is available on all drives that data and log files are on?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 7, 2010 at 8:15 am
How are you copying the data? SSIS sometimes will generate huge log files and take ages to copy large amounts of data where a simple SQL statement will often run quicker without the same amount of logging.
e.g.
--into new table
Select FirstName, LastName INTO dbo.tb_A FROM dbo.tb_B
--or into existing table
INSERT INTO dbo.tb_A (FirstName, LastName)
SELECT FirstName, LastName
FROM dbo.tb_B
If it across 2 servers set up one as a linked server on the other then modify SQL e.g. .....from [linkedservername].dbo.tb_B
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply