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 |
|
CanadaDBA
583 Posts |
 Posted - 2005-02-08 : 14:27:51
|
| The plan that my manager suggests to replace our old server is like: 1. Implement an exact SQL-Server as our production on new machine.2. Testers test on new machine and it may take 2 or 3 weeks. 3. After Testers finished, I will get a backup from current databases in production4. Old server will be replaced by new one and I will restore backups.My question is that if there is any UDF or stored procedure update in production during 2 or 3 weeks that Testers are testing, then would I lose that update by just RESTOREing the databases? In other words, where UDF and SPs are located? In the database or in system databases - master or msdb? Canada DBA |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-08 : 14:42:23
|
they're stored in your db.look in EM or QA when you open a database tree there's a leaf that say stored procedures and another that says user defined functions.Go with the flow & have fun! Else fight the flow  |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2005-02-09 : 10:46:59
|
So, any UDF or SPs update won't impact anything. Is there any other risk(s) for my situation (The plan)? quote:
Originally posted by spirit1
they're stored in your db.look in EM or QA when you open a database tree there's a leaf that say stored procedures and another that says user defined functions.Go with the flow & have fun! Else fight the flow
Canada DBA |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-09 : 10:56:18
|
| if you restore the db all of the sproc's and udf will restore also to the state they bere backed up.after update you should probably run DBCC DBREINDEX, DBCC DROPCLEANBUFFERS, DBCC FREEPROCCACHE...someone will probably add more to this.Go with the flow & have fun! Else fight the flow |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-02-09 : 11:30:01
|
| Best advice....'investigate a change-control system + policy' for your SP's, UDF, DDL, etc so that changes are implemented in a controlled manner....changes direct to a 'test' database should be scriptable....and replayable!Search here for advice on some good/best practices. |
|
|
|
|
|
|
Where are UDF and SPs?