Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blackX
Posting Yak Master
102 Posts |
 Posted - 2007-11-12 : 13:33:52
|
| Hello, I have been give a task of making sure that our stored procedures are being backed up as part of our daily backups. I also was asked to find out where the stored procedures are stored at.Thanks for any and all helpTravis |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-12 : 13:35:08
|
| Stored procedures are located in the database inside syscomments. You won't find them on disk.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2007-11-12 : 15:20:34
|
quote:
Originally posted by tkizer
Stored procedures are located in the database inside syscomments. You won't find them on disk.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
ok thanks that is kind of what i was thinking. One more question, would these be included in FULL backups? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-12 : 15:27:11
|
| Yes.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-11-14 : 10:12:49
|
| But you should have them scripted and stored elsewhere!Ok its easy to change hte SP on the fly in development and then make the same change in production . . . . . But what if you have 20 , 30, 40 Production instances . . .Thats where running a script comes in handy. I store mine on my laptop, and update a server with changes on a regular basis, and when I change Production omes they get written into source control. That way I can go back to a previous version when the developers make a mistake :) NOt that it gets by me ;), but they have overwritten the development one and need to go back to what is in live.So if you don't have scripts for your stored procedures, I suggest you Right Click the Stored Procedures leaf in EM and choose Generate SQL Script and follow the wizard.-- RegardsTony The DBA |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-14 : 11:15:32
|
| If they are xps' they may link to dll's you should make sure that this being the case the dlls are backed up too. |
|
|
|
|
|
|
Location in File System of stored procedures