when you right click the job-properties you see the owner, you might change the owner to some Other user acct, probably the SQl Server Agent Service actt. Or as mentioned...

= You can also use drive-letter swapping to move the databases to a new storage site. Make sure you have backups for all the databases being moved.

= Copy the system...

Good info by BRIAN.

Truncate Transaction Log will truncate the the inactive transactions in your transaction log and shrink the transaction log file, but this will not reduce the TRANSACTION LOG File Size,

Whereas SHRINK...

did you use the TUNING Trace available in SQL Server Profiler. Or was it a standard trace. USE TUNING TRACE.

at the minimun if you are building a custom trace have...

You will have to list down the Logical names the first time.

then you can put the Names in a Automated Scripts in the JOBS, and WOLA! you are ready...

Configure DatabaseMail or SQLMail on the Server and if you Auto Apply the Log using a JOB, use a STEP in the JOB, to send out Email message.

I Agree 🙂

Check out http://www.sqlskills.com and Paul Randals Blogs, he explains about SHRINK operation and how they cna cause fragmentation, which in return can take us LOG SPACE. etc etc

I will Mike's suggestion: nothing better n Easy than Backup and Restore.

something like this:

SINCE THIS IS THE SAME bOX AND SAME PATH TO DATA FILES, I WOULD SUGGEST THE...

right there with tosscrosby.

Check your SQL Server memory Settings.

Post the SQL info as requested by tosscrosby, then we can figure out the issue (if there is).

Do you see a performance...

well i am not sure totally, but try using only "BAK" and not ".BAK"

Again: did you make any changes to the JOB's outside the Maintenance Wizard, if you did, This...

Again some Pointers for Responding to full transaction log is:

Backing up the log.

Freeing disk space so that the log can automatically grow.

Moving the log file to a disk drive with...

I hope your issue is solved by now, but if it is not, then RUN this Query and post back the Results:

select database_id, log_reuse_wait, log_reuse_wait_desc from sys.databases

Where database_id= your_databaseID_Here

Try using OpenQuery something like this:

SELECT * FROM OPENQUERY([OracleLinkedServer], 'Update SQLTable Set NX.Field1=''I''

From ..OracleTable.FieldA AS ORA

Inner Join SQLTable AS NX

ON ORA.NOV_ID = NX.NOV_ID

AND NX.Field1=''L''...