Derrick Smith (9/27/2011)

---

You will need to use a domain account for this. Pick one and give it the appropriate access on the publisher, and then set the log reader/etc to...

Thanks

It helped me and saved time.

Do you have sysadmin rights? Or are you executing xp_cmdshll under proxy account?

Does your folders have enoug permissions where you or proxy account could access them?

Neepa

When the SPID is rolling back and really something is happening ( I mean the SPID is just not hung ), even if you restart , sql server has to...

Assuming that you are passing the script to be executed in @SQLStat parameter, your procedure should be:

create proc ExecuteScripts (@SQLstat varchar(max))

as

begin

exec ( @SQLstat )

end

Also check sp_executesql if you need to...

Get the SPID of the killed/rollback command.

check DBCC INPUTBUFFER (SPID ) to see which command is rolling back.

If the DROP is rolling back, just stop the truncate statement and close...

Truncate the table first and then drop it.

Neepa

Also, think about getting a backup tool like sql backup from RedGate or Litespeed from Quest. They compresses the backups very well and have proven blessings whenever I ran into...

Rikk,

If you are not concerned about loosing log history, see if you could truncate it one time and shrink the database. ( I am sorry I don't have this table...

And then you end up as a DBA in the company where they try to last for years without actual DBA. My last workplace had databases grew to 8-9 TB...

We have way too many variables right now in the picture in general:

-Moving to virtual enviroment

-Possibly upgrading from 2005 to 2008 also from 32 bit to 64 bit sql server...

Thanks Steve and Richard for your guidance.

I have started getting more info. These are actual PDF documents that we have to store.

Filestream would have been the better bet but since...

Just got the updated requirements. According to that the storage requirements can vary from 150 GB to 400 GB a day. I don't think that I can incorporate that kind...