x

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.

more ▼

asked Mar 28, 2013 at 10:41 AM in Default

avatar image

jctronicsshiva
470 14 14 19

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.

Apr 01, 2013 at 09:29 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Mar 28, 2013 at 11:17 AM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Mar 28, 2013 at 10:48 AM

avatar image

tanglesoft
1.8k 4 6 11

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1089
x476
x129
x84

asked: Mar 28, 2013 at 10:41 AM

Seen: 1076 times

Last Updated: Apr 01, 2013 at 09:29 AM

Copyright 2017 Redgate Software. Privacy Policy