Is your batch command being run from a centralised server..if so the error occurs only if the batch file is removed from there.

However, please post your error with some more...

Shrinkfile does not work every time. Find out why the log grew so big first then you can fix it. If you said you have the database in Full recovery...

GSquared (1/12/2009)

---

I think your best bet is load into a staging copy of the database, copy the files to the production server, then take the production database offline and attach...

To check for any queues in the msdb on account...

USE msdb

SELECT TOP(30) OBJECT_NAME(object_id), rows

FROM sys.partitions

ORDER BY rows DESC

Run this and see if you can find any hints..

Thanks!!

This could be on account of a large DML operation overnight?

If that were to be the case, do you have transaction log backups running in the night too...my assumption is...

What version of SQL server is this?

Correction for 2005 Use this :http://msdn.microsoft.com/en-us/library/ms144256(SQL.90).aspx

Thanks!!

See this : http://msdn.microsoft.com/en-us/library/ms143393.aspx

Thanks!!

Is the login a user on the remote server? If not use option:

login using the current users security context and enter the login and password by going into the properties...

If...

tempdb on C drive..how big is the drive itself.

As a best practice place tempdb on a disk with high throughput, like a RAID 10.

Well, you can move tempdb to this...

If they are member of a Group in windows then take them of this group that way they can't login to SQL. Create an AppUser login with SQL Authentication and...

Per CPU is the most often used licensing type when it comes to big organizations..the more the CPU's the higher the cost

Ex: SQL 2005 standard supports only 4 CPUS -...

Did you dig in on SQL Response?

Thanks!!