As stated above the changes wont let you go back and the user databases should not be affected. Just make sure you have some good current backups...then worst case...

To my knowledge and i have been in your shoes there is no way you can track the kind/type of license you have within SQL. This is usually something...

yes ...when looking in sysservers it is the second entry..

Thanks everyone.. much appreciated...

-D-

ssc comes thru again...as usual 😎

Its ran during production hours because this system i have will monitor over 140+ sql servers and these servers are worldwide. So if there is a problem and my...

thanks a lot.. much appreciated and will try the scripts you passed along...

Thanks again

I have a queston and hopefully its not offensive.. but the obvious is this.. Do you have any previous backups of your system databases? If so you can...

Hey hey

I am not sure about your environment but i can offer the advice of be careful as to having other stop and start the mssqlserver services. I know...

Good thought process while concerning the growth rate. But i would also think about the fact that at 300GB the server is relatively small in comparison to whats out...

If i am reading this right you are asking that if you have both the production(source) and DR(target) on the same line (network) will it cause problems. Yes, this...

I have used the follwing link to help with login transfers;

http://support.microsoft.com/kb/246133

Its helped me more then once. You may also want to look on the scripts pages inside of SSC....

Going form SQL 7 to SQL 2k5 is a big jump mostly becuase a lot of the system components change. Also be sure to have a solid backout plan...

one other thing you may want to do before your migration is to use the SQL Advisor. This will give you some ideas of the possible bottlenecks or problems...

Well, I do know that the new setup will detect whats going on and how. But its unclear as to if you are going to add the new...

Thanks for the insight Pam... but i cant run an advisor simply because the migration is going across to 2 separate servers..one will remain 2k and the other will remain...