I have backup files getting stored in its own individual directory for each database and I use below code to delete files older than 3 days. It works well.

DECLARE @OD...

select replace(email, '@abc.com', '@gmail.com') as Email, Ename from #emp

Thanks Perry...

Perry Whittle (7/12/2011)

The backup job on the primary server does...

I don't think you need to have two different log backup jobs now. Log shipping job on Primary server will do the log backup and copy it over to the...

Yes you were right. There was a permissions issue. I was using a SQL login to connect to linked server and that login needs to have sysadmin rights on the...

One question though,

when I execute,

EXECUTE MyServer1.master.dbo.xp_fixeddrives -- It gives me drives available and free space result

But the same thing for another server gives me no result. It runs successfully but...

Thanks Elliott...

Does this require restarting SQL Server Service too?

Thanks...

Thanks again.

Thanks for the reply Sean. I will make sure I post in the right forum next time. If you like you can move it. And sorry for position it at...

Thanks for the quick reply George. One more question,

If SQL Server Service still runs under Local System Account and SQL Agent is Changed to run under Domain Account, that...

Thanks...

Sure... We use windows authentication for all the servers. Do I need to make any security considerations for that?