I have 2 servers: 2008 standard DC with AD that also has SQL 2005 standard and a 2003 server that is just doing Terminal Server. My backup media is a NAS device on the network.
I am trying to figure out the best way to install Backup Exec 12.5 in this environment. The 2008 server is running 2005 SQL standard which hosts our primary database (about 3gb in size). When I started installing the BE12.5, it prompts to install SQL express for the database or use an existing instance. This caused me to consider all the implications of this choice.
How do I setup my BE 12.5 in the best way for this situation:
1. Server - best to use the 2003 Terminal Server or the 2008 DC?
2. If the 2008 server, Do I use the new instance of SQL Express (and run sql express and full sql on the same box)? Or do I use the existing Full SQL software a put the BE database on that?
3. If the 2003 server, no SQL on there so the SQL express would be only option, but most of the critical data to be backed up is on the 2008 server.
Any assistance would be greatly appreciated.
I am giving this a points value of 500 because its a holiday weekend.