Viewing 15 posts - 1 through 15 (of 33 total)
ok thanks a lot. I will give this a shot and mark it as a solution once it works 🙂
August 27, 2015 at 2:42 pm
ok thanks, I will give it a shot. So sorry if this is a silly question, but after I have created the synonyms, any stored procedure which references source schema...
August 27, 2015 at 2:10 pm
Ok so please tell me if I am understanding this correctly: Say all tables & stored procedures in my source environment follow the schema names "source." and in my destination...
August 27, 2015 at 1:32 pm
Thanks for the suggestions guys. I looked into synonyms. Can I create synonyms for schema names? I ask because the MS link below seems to indicate that I can NOT...
August 27, 2015 at 1:01 pm
Also Gianluca, just to clarify the new drives G:\ and H:\ are already attached to this server and our requirement is to use the new drive letters.
October 28, 2014 at 11:02 am
Thanks Gianluca, I appreciate the response. Doing any OS activities at this point is not an option since IT team is caught up with major projects. So it would have...
October 28, 2014 at 11:00 am
Hi thanks Alvin - the tables in question don't have a date column. From what you are saying, I take it SQL keeps track of when a record was inserted?...
October 14, 2014 at 7:50 am
Thanks for the responses guys. But the reason I asked for some numbers is because, as mentioned by some on this thread, the recruiters often try to get me to...
August 19, 2014 at 11:23 am
Thanks for the responses guys. So far we have moved 8 of the smaller databases via simple backup and restore with no issues. However needed further guidance on the 3...
August 6, 2014 at 11:36 am
Thanks for the response Gila. Any comments or experience on moving the files of VLDB's over the net? I am particularly concerned about the time it might take to copy...
July 31, 2014 at 2:16 pm
I appreciate all the replies guys. Markus, thanks a lot of the script also. Please keep adding whatever you seniors feel will help. Thanks!
June 19, 2014 at 10:38 am
So I would have one last question for the team here. My maintenance plan was set to backup all databases. However it was unable to backup the one database db10,...
May 17, 2013 at 3:46 pm
You know what - you are right. Actually the maintenance plan is setup to create a sub-directory using EXECUTE master.dbo.xp_create_subdir and it creates it using a trailing space. Since...
May 17, 2013 at 3:09 pm
Lynn Pettis (5/17/2013)
I may be wrong but is there a trailing space in the name db10? Above in brackets it looks like this: [db10 ] indicating a space...
May 17, 2013 at 2:20 pm
Thanks for the explanation guys. Much appreciated.
May 6, 2013 at 8:44 am