question

jctronicsshiva avatar image
jctronicsshiva asked

Common Stored proc- usage related

Suppose I have generic stored procs for backup and restore. Where to run these stored procs from?is it fineto run from the master db? if not please suggest me the best practice.
t-sqlstored-proceduresrestoredatabase-design
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
If any of these answers was helpful you can show that by clicking on the thumbs up next to those answers. You can vote for more than one. If any of these answers solved your problem, indicate that by clicking on the check mark next to it. You can only mark one answer as the solution.
0 Likes 0 ·

2 Answers

·
Grant Fritchey avatar image
Grant Fritchey answered
You can put them into master or msdb, but remember, you never know when anything you put into a system database could get removed by a service pack or update. I've never seen it happen, but Microsoft always warns that it might, so it's something to consider.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

tanglesoft avatar image
tanglesoft answered
I put generic backup stored procedures in msdb rather than master. The only reason is that this is where all the SQL Agent related tables and procs are.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.