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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2008-02-05 : 03:08:01
|
| Hi thereIs there any issues to point the Microsoft SQL Server Upgrade Advisor to the SQL2K production environment during normal hours? Any issues that you know of? Or anything that I should to know about this tools?Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-02-05 : 03:28:49
|
| it really wouldn't be a best practice to do something like this.you should run the advisor against other databases to understand how it works first. I personally would run the advisor against a copy of prod, not the actual prod environment - but that is just me being a dba.-ec |
 |
|
|
Sireesh
Starting Member
4 Posts |
Posted - 2008-02-05 : 15:39:12
|
| Hi,Upto my knowledge there wouldn't be any effect by running upgrade advisor aainst production database.But,don't install that on production server install that on any other box which is in network.Regards,Sireesh |
|
|
|
|
|
|
Microsoft SQL Server Upgrade Advisor