Putting the Go word after the second bcp?

I think that the server use it for internal functions. There's nothing you can do with them. I guess that you can't kill them either.

I don't know the answer, but check a few days ago topics because someone gave the solution to the exact problem that yoy have.

Did you run dbcc checkDB on those databases?

Any error logged on the Event Viewer?

A thread logs all the pending transactions in the Transaction log. SQL manages the times when this thread is fired, it depends on the free buffer memory and the time...

Before the Checkpoint, the database is not syncronzed, the changes are saved in the Transaction log but not in the data files.

After a checkpoint, all the transactions that are in...

Do you have a backup of the registry? That would also help.

If you can't make backup so I think that you can try dettaching the dbs. Do you have the...

Do you have join sentences executing...remeber sql use tempdb to execute joins. Maybe you should check how the queries are builded and maybe consider checking indexes.

There are many options that come with the SQL backup utility. If you used them all I don't see why you would use a third party utility.

Well done boys. I'm from Argentina and it been a short time since I reply to the topics.

I spent most of the time submitting scripts, but I understand the need...

Also try books on line from SQL Server. To get help from the create database sentence search it in Books on line or Open Query analizer and type Create database,...

Every time you truncate the logs you should do a full backup. Because if a dissaster occurs the you won't be able to recover until the last minute, only until...

Can you post an example of the bcp command you used?

the default sql server user name is sa with a null password. Check with Query analizer to log with that user.

If they are correct, then use that info to execute...