I have a SQL2008 server with some DBs.
And now I installed a test server with SQL2012.
I need to copy my DB to the new test SQL server.
Is it possible to do this with a task from SQL Management Studio ?
What about to create a mirror or a replica ?
And if its possible how to do this ?