Reindexing will definitely grow the log file. I would just run my full backup and a TX Log backup after the reindexing job

Begin Try

Begin Transaction

Update source set model = 1 where client 2

COmmit Transaction

End Try

Begin Catch

Rollback transaction

End Catch

Begin Try

Begin Transaction

UPdate...

** edit -- posted while you were posting the real code **

Can you post the original code so we can actually see what you were doing and propose a solution...

Can you post your .NET code? Do you have SSMS Express installed and, if so, can you run the backup from the app machine using SSMS Express?

Terry (5/13/2008)

---

Actually the update statement is a bit more complicated.

Let's say that i get the phone number from another embedded select (that's why i put values likes XXX and YYY).

The...

Looks to me like you just need 1 update statement in a stored procedure like this:

[font="Courier New"]CREATE PROCEDURE update_phone_no

   (

   @id INT,

   @phone VARCHAR(15)

   )

AS

UPDATE Clients

   SET phone = @phone

WHERE

  ...

LocalSystem would be the default and should not cause the non-connection issue. Is IIS running?

I have not used the CLR as yet, and have not really seen a compelling reason to use it. I try to avoid situations where strings need to be...

On the job step you can specify a number of times to retry a step on failure along with how long to wait between retries. You really need to...

Let me make sure I understand your issue, you have a full db backup and a single file with 175 log backups since the full backup. What your code is...

One way would be to generate a random number, see this thread for one way, and then use start_date = DateAdd(day, random_number, getdate()) and end_date = DateAdd(day, random_number + 1,...

Can you post your application's connection string? Changing sensitive information of course. I ask because the error you are getting is telling me that you are attempting to...

Is this SQL Server 2005? Did you tell Reporting Services to start during the install?

You need to go to SQL Server Surface Area Configuration -> Configuration for Services and...

You are right it is messy. There is a lot going on here, can you provide a brief explanation of the business rules for the code? I also...

You use the Error data path. The only thing I can think of is that you need to Configure Error Output for the Transformation task and set it to...