Thanks everyone for your response.

I know shrink is bad idea but as Paul said we do it with calculation. We try to shrink the log file to 1/4 of...

Thanks Andrew.......

I got that a.size from sys.database_files stores file size in terms of 8-KB Pages and multiplying that by 8192 is to convert it into KB. So let's say a.size...

I know my basics very much I am not asking you to give me entire code only thing I am asking is a which system table, view, dmos etc store...

I don't need any third party tools................

Thanks for quick response.

But both of them will not be giving me estimated number of records fetch by each operator...

I am now trying to have upload job for server activity run 3 times a day every 8 hr. Also I have given retry attempts and retry interval to 1...

I am facing similar issue only for Server Activity Collection Set. IT upload job runs for more than 1hr it fails with below error message

the thread "ExecMasterPackage" has timed out...

I have seen many times that maintenance plans do not completely delete files or throws error. so i would suggest you to write a seperate job may be using vbscript...

First solution will be to move tempdb to other drive and start sql server.

after that you will not require to failover the mirror database.:-)

Are you trying to restore from network drive, if yes then please check the network is stable between two servers.

Try verify the backup file....

Can you please try to explain in detail what permissions you have on sql server and what type of authentication you are using.

Hi All,

I did this test in my test server, like having sp4 on mirror for sql server 2005 and sp3 on sql 2005 for principal and then configured mirror. I...

Thanks for your reply...

What I was looking for is will there be any sync issues happening in as my mirror will be on SP2 for 2 -4 weeks while principal...

Yes it is very much possible if you can create linked server.

My questions is why do you require select into another table in same database ?