ok thanks a lot. I will give this a shot and mark it as a solution once it works 🙂

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...

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...

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...

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.

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...

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?...

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...

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...

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...

I appreciate all the replies guys. Markus, thanks a lot of the script also. Please keep adding whatever you seniors feel will help. Thanks!

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,...

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...

Lynn Pettis (5/17/2013)

Like2SQL (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...

Thanks for the explanation guys. Much appreciated.