Backup primary file groups with no procedures

Suggestions welcome please.

I would have to handover my DB with only Primary tables to client as part of SLA. 
I am planning to keep these primary tables on a secondary file-group but how-ever, I will still have my procedures on primary file-group. 
How can I accomplish this with client having no exposure to my stored procedures. 

Thanks,

August 20th, 2015 5:30pm

That is not going to work with BACKUP/RESTORE, since you cannot restore only a secondary filegroup, but you must always restore the primyar filegroup.

You would need to create the tables from scripts in a second database and copy data over.

Free Windows Admin Tool Kit Click here and download it now
August 20th, 2015 6:15pm

Thank you Erland, I figured something similar, along those lines. But, I feel much better when an Industry expert confirms the same.

Thanks once again.

August 21st, 2015 12:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics