roland.hangg (9/23/2014)
Thank you for your tips. I use the script since many years and it always worked fine for me. O.K. I dont use blanks in my path and filenames (old school:-)) and I dont have domain admin permissions. Only DB-server wide (local admin and sysadmin role).Regards, Roland
Please don't get me wrong, maybe my lack of knowledge, but I don't understand how can local admin/sysadmin account on one server connect to another server ( I presume local admin/sysadmin on one of the servers is not the same). On my dev sql instance SQL 2008R2, my account is sysadmin and local admin also, so I expected that would work. Maybe I'm missing something.
So could you explain me this a bit, please?
Cheers,
K.
P.S. the reason I wrote domain admin account (which is almost never the case) is that I also tried to make copy of small DB from another server to my local server, and was not able to do it, becase paths to FS were not correct. And usually people are using instance name, but in my test scenarios it happened to be that I used default instance.