you can restrict the tempdb log file size ,so that it will stop growing and log file will get reuse .

and then you can try to shrink .

also restarting the...

its 64 bit

sql server uses maximum it want on 64-bit machine and reserve it even though its ideal.

when other applications on server needs memory it will release it ... so...

wait till query get completed.

verify whether data getting insert or not by using

sp_spaceused 'tablename'

look at the rows.

create a sql server windows authentication login .

if you already have try remove and recreate.

Try this

http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30962/

i agree.

Ola's script is wonderful. It reduced my time from 10 hours to 2 hours.

also he reply you quickly if you want to modify the script.

I got it wrong.

thanks for Posting 🙂

did you check RPC and RPC out options in linked server properties ?

Make it true and Try

u can follow these steps

check which query is lock the object u r trying to truncate by following.

Select blocking_session, sid, serial#, wait_class,seconds_in_wait From v$session where blocking_session is not NULL...

Incremental Backup = Transaction log Backup

Check if the auto-close option for database is on,if yes make it false

use isnumeric() function for the column on which u get the data conversion error.

the domain account under which your sql server is running may be dont have local administrator privilage.