DBAs... please be gentle with me, I'm a 'greenhorn' SQL Server DBA, pressed into service because my company's DBA had resigned and we haven't found his replacement, yet.
First, my situation:
I'm supposed to 'transfer' a web-app from a server in Singapore to a (pair of) newly-built server(s) in Indonesia. Unfortunately, the Singapore DB server is running SQL Server 2005 Express Edition, while the new server is running SQL Server 2008 R2. To make things worse, the developers of the web-app is no longer supporting us (we're practically coasting with the last version of the web-app)*.
I plan on creating a new Instance on the SQL2008R2.
I have several questions that have been bugging my mind:
How do I find out what 'features' (e.g., Reporting Service, Replication, etc.) has been installed on the Singapore server?
How to ensure a complete backup (Databases and Stored Procedures and other relevant tidbits)?
I noted that there are several Stored Procedures (not many, just 4 that I can see under the "Databases\AppDB\Programmability\Stored Procedures" tree), how to ensure successful migration of these Stored Procedures? Any gotchas I need to be aware of?
Thank you for any inputs.
* The plan actually is to just migrate the web-app as a "read-only" app for archival/audit purposes; management has plans to deploy a better web-app in its place.