I have SQL Server 2012 Express installed on this server. However I cannot automatically run a backup job since the SQL server agent cannot be automated on Express version. Which is fine as I knew about it before implementing 2012 express.
I also have the SQL Server 2008 R2 Standard - fully licensed software. What I want to do is:
1. Install SQL Server 2008R2 as well on the same server ( as a second instance ) - I believe this is possible ?
2. Then once this is installed - create a backup job to back up one of the SQL Server 2012 express databases. Is this possible ?
if so how would i do it ? Would I be able to install another instance of the SQL server Management studio for 2008 R2 so I can create a job ? Most importantly as asked above, will the 2008 R2 SQL agent backup a 2012 database ?