I didn't investigate the main reason for slowing down, but I have noticed the difference in performance after adding a file to tempdb, I expect that something happened made the...

I just want an automated process, that's why I thought about using copy db

I want to schedule recurring copying database from production to test

I have read an article about droping the old and reduntant stats , to keep only the used stats

copied

" This may sound like a radical idea at first, but...

Thanks for replying

I just want to detect performance on overall database, to see if any recommendations are exist to apply it and increase db performance.

any idea

(you may have to run a checkpoint or two before the log rolls over to the free space to allow shrinking) will work,

how to run a checkpoint?

Thanks

is it correct to convert the recovery model to simple then shrink the log file

Thanks

any idea how to solve this problem

is it correct to make backup log then shrink the log file

Thanks

can i shrink the log file

I want to solve the space problem

yes, the problem was that I configered that the bcp is a case sensetive , when I wrote -c -T capital T , it is solved

Thanks for your concern

any help

do you want to enter my server remotly?

we can use program named by teamviewer

when I wrote on -Shome not -Shome\mssqlserver

this error occured

C:\Users\Dell>bcp medica.dbo.patient in d:\patients.txt -c -t -Shome\mssqlserver -Usa -PP@ssw0rd

SQLState = 08001, NativeError = 87

Error = [Microsoft][SQL Server Native Client 11.0]SQL Server...

unfortunately there is no SMTP or Exchange server, thats why I am thinking about popup message

how this could happen

Thanks