February 1, 2007 at 6:52 pm
hi Everyone,
I am getting errors on:
Error messages:
The process could not bulk copy into table '"Data"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: http://help/MSSQL_REPL20037
Batch send failed
The transaction log for database 'SWEETWATER' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases (Source: MSSQLServer, Error number: 9002)
Get help: http://help/9002
To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command that appears below. Consult the BOL for more information on the bcp utility and its supported options. (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253
bcp "SWEETWATER".."Data" in "C:\BnB_ReplData\unc\SWEETWATER3_SWEETWATER_SWEETWATER_PUBLICATIONS\20070130173243\Data_10#2.bcp" -e "errorfile" -t"\n<x$3>\n" -r"\n<,@g>\n" -m10000 -S14419-26632 -T -w (Source: MSSQLServer, Error number: 20253)
I run the BACKUP LOG sweetwater WITH TRUNCATE_ONLY
and DBCC SHRINKFILE (SWEETWATER_LOG, 200)
The DBCC SHRINKFILE did not work in MS SQL Server Managerment Studio.
Can anyone helps.?
Thank a lottttttttttttt.
TJ
February 1, 2007 at 7:10 pm
How is the SNAPSHOT which is doing bcp?
what is very current log size and used size?
how much free space do you have on the disk?
Is transaction log file growth configured to unrestricted file growth?
When you have active traction log will not be truncated...
MohammedU
Microsoft SQL Server MVP
February 2, 2007 at 8:20 am
Hi MohammedU,
I was setup transactional replication. The snapshoot went completed.
The current log size 819200 KB and maxsize 819200 KB.
The disk still have plenty of spaces.
The growth size 102400 KB.
How do I check the log is not truncate?
February 2, 2007 at 1:25 pm
You Mean your log size is 819200 KB and used log size is 819200 KB?
What is the recovery model of th db?
Tell .ldf file size total, used and free space?
Are you running tlog backups on this server?
You can use DBCC LOGINFO command to check the log...
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply