Bulk Copy Failed During Snapshot

I'm trying to start a new publication. When the snapshot agent runs, it stops on a table with the error "Bulk Copy Failed". If I remove the table from the publication, it just moves the error to the next table it tries to copy. What could cause a bulk copy to fail during a snapshot?

Hello,

In order for any of us to provide further assistence, we will need:

1) The version of SQL Server that you are using

2) Additional information regarding the nature of the error. You can probably find this through the error details pane in the UI or you can select it directly from the MSrepl_errors table in the distribution database.

-Raymond

|||

Sorry about the lack of info. I've been working on this off and on for 2 months and have gone brain-dead trying to figure it out.

Version:

SQl Server 2000

on Windows Server 2003

Error message:

The process could not bulk copy out of table '[dbo].[xxxxx]'.

Error details:

I/O error while writing BCP data-file
(Source: ODBC SQL Server Driver (ODBC); Error number: 0)

Thank you

(edited to correct versions)

|||

I am guessing this really is SQL2000 as the snapshot agent is using ODBC for performing the BCP operation. (There is no SQL2003)

The error "I/O error while writing BCP data-file" is typically caused by the lack of disk space on the snapshot drive. It may be a good idea to check if you have sufficient disk space on the snapshot drive.

Hope that helps,

-Raymond

BUILTIN\Administrators

Hi,
I must remove BUILTIN\Administrators. Should i create 2 domain accounts, one for each service (MSSQLServer, SQL Server Agent) or one for the two services ' actually i'm using LOCAL SYSTEM ACCOUNT.
If i use 2 accounts i must give sysadmin for the two accounts, and i don't use the account sa, i have one other account with sysadmin permiss=F5es for my day by day work. When i use MBSA, i always get the message that i have more than 2 sysadmins. How can i troubleshoot this question '
What is your approach of remove BUILTIN\Administrators and start the accounts with domain non admin accounts ?
My approach:
-Remove BUILTIN\Administrators
-create one domain account with regular priviledges
-assign the account for the two services
-grant SQLServer sysadmin rights on the account
Can anyone give a nice approach for this question ? issues regarding the change ?
Thanks in advance for the help
Miguel
MCPI would use 1 domain account... The necessary permissions can be found in
books on line. Search for "service accounts"
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Miguel" <anonymous@.discussions.microsoft.com> wrote in message
news:05fc01c3db7f$f6c96870$a001280a@.phx.gbl...
Hi,
I must remove BUILTIN\Administrators. Should i create 2
domain accounts, one for each service (MSSQLServer, SQL
Server Agent) or one for the two services ' actually i'm
using LOCAL SYSTEM ACCOUNT.
If i use 2 accounts i must give sysadmin for the two
accounts, and i don't use the account sa, i have one other
account with sysadmin permissões for my day by day work.
When i use MBSA, i always get the message that i have more
than 2 sysadmins. How can i troubleshoot this question '
What is your approach of remove BUILTIN\Administrators and
start the accounts with domain non admin accounts ?
My approach:
-Remove BUILTIN\Administrators
-create one domain account with regular priviledges
-assign the account for the two services
-grant SQLServer sysadmin rights on the account
Can anyone give a nice approach for this question ?
issues regarding the change ?
Thanks in advance for the help
Miguel
MCP

BUILTIN\Administrators

Hi,
I must remove BUILTIN\Administrators. Should i create 2=20
domain accounts, one for each service (MSSQLServer, SQL=20
Server Agent) or one for the two services ' actually i'm=20
using LOCAL SYSTEM ACCOUNT.
If i use 2 accounts i must give sysadmin for the two=20
accounts, and i don't use the account sa, i have one other=20
account with sysadmin permiss=F5es for my day by day work.=20
When i use MBSA, i always get the message that i have more=20
than 2 sysadmins. How can i troubleshoot this question '
What is your approach of remove BUILTIN\Administrators and=20
start the accounts with domain non admin accounts ?
My approach:
-Remove BUILTIN\Administrators
-create one domain account with regular priviledges
-assign the account for the two services
-grant SQLServer sysadmin rights on the account
Can anyone give a nice approach for this question ?=20
issues regarding the change ?
Thanks in advance for the help
Miguel
MCPI would use 1 domain account... The necessary permissions can be found in
books on line. Search for "service accounts"
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Miguel" <anonymous@.discussions.microsoft.com> wrote in message
news:05fc01c3db7f$f6c96870$a001280a@.phx.gbl...
Hi,
I must remove BUILTIN\Administrators. Should i create 2
domain accounts, one for each service (MSSQLServer, SQL
Server Agent) or one for the two services ' actually i'm
using LOCAL SYSTEM ACCOUNT.
If i use 2 accounts i must give sysadmin for the two
accounts, and i don't use the account sa, i have one other
account with sysadmin permisses for my day by day work.
When i use MBSA, i always get the message that i have more
than 2 sysadmins. How can i troubleshoot this question '
What is your approach of remove BUILTIN\Administrators and
start the accounts with domain non admin accounts ?
My approach:
-Remove BUILTIN\Administrators
-create one domain account with regular priviledges
-assign the account for the two services
-grant SQLServer sysadmin rights on the account
Can anyone give a nice approach for this question ?
issues regarding the change ?
Thanks in advance for the help
Miguel
MCP

Builtin\Administrator login

Hi All,
How can I tell what account SQL Agent configured to start up with? Local or domain?In Enterprise Mangler, right click on the SQL Server Agent and select Properties. If you can't connect to the server, look at the Service in Windows services, and click the "Log On" tab to see the login information.

-PatP|||I looked in Enterprise Manager and the radio button next to System Account is selected. Is it local or domain?|||Local. If it were a domain administrator, the domain name would be a prefix such as MyDomain\Administrator in the box.

-PatP|||Thank you.