I m using log shipping for the database now but i have to kill the connections to restore the recent backup. 🙁

Is there any other way of not disturbing the...

Thank you very much will disconnect the users before i restore. Thanks once again

tried to map the network drive with username and password but no luck

Do you know what is the syntax of NET use in my scenario ?

I mapped the network drive in sql sevrer box and i have ran this

EXEC xp_cmdshell 'FORFILES /p I:\ /m *.* /d -30 /c "CMD /C del /Q /F @FILE"'

ERROR:...

Thank you for the recommendations

R

How can i find out if something goes in a loop?

I do believe that another drive will be the solution myself.

Hello there

You helped me out thank you so much have seen the permissions and logged on as that account the language of that acount was different changed it to...

the query is this

SELECT Number,

CreatedDateTime,

subject,

convert(varchar(20), Incident.CreatedDateTime,103) as CreatedDate,

FirstCallResolution

FROM Table1

WHERE CreatedDateTime >=

CASE DATEPART(WEEKDAY,getDate())

when 2 then dateadd(day,datediff(day,0,GetDate())-3,0) --mon

...

Sorry i didnt explain myself properly, :crying:

My SSIS package is doing the following export (export wizard was used to create the SSIS package) some of these data to another table...