SSMS 2012 Vs 2008

Question

SSMS 2012 Vs 2008

sqlfriend

SSC Guru

Points: 52781
More actions
August 12, 2014 at 12:24 pm

#294366

After we upgrade some of servers from SQL server 2008 to 2012, I found it is harder to use 2012 SSMS to restore database compared with 2008 SSMS.
Anyone else has the same experience?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

sqlfriends (8/12/2014)
After we upgrade some of servers from SQL server 2008 to 2012, I found it is harder to use 2012 SSMS to restore database compared with 2008 SSMS.
Anyone else has the same experience?

Harder how?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Mike Good SSCertifiable Points: 7415 More actions · Answer 2

Mike Good

SSCertifiable

Points: 7415

August 13, 2014 at 7:48 am

#1737582

Not me

sqlfriend SSC Guru Points: 52781 More actions · Answer 3

In SQL 2008 SSMS, when I want to restore a database from another database, or a file from a device,

I click the database that I want to restore, then click restore database, on the next screen, I choose the source database or device I want to, it is very easy and straight forward.

But for SQL 2012 SSMS, I do the same way, that is click the database that I want to restore, then click restore database, on the next screen, I change the source to another database, then the destination databse name changed too as the same as source. I have to change back the destinatation name to the database name I want, but when I click files tab, nothing shown.

What could be wrong?

Thanks

Mike Good SSCertifiable Points: 7415 More actions · Answer 4

I see your point. I never use SSMS this way, did not notice that difference. If using SSMS GUI, I generally choose "restore database" from the "databases" folder, and then specify both source and dest--that process is not any worse in 2012 than in 2008.

sqlfriend SSC Guru Points: 52781 More actions · Answer 5

I also tried your way.

That is click databases, - restore database, I specify both the source databse and destination databse,

the list of backup file is shown, then I chose the one, but on next screen Files tab, I see nothing.

This is really confusing.

Please see my attached screen shot.

Mike Good SSCertifiable Points: 7415 More actions · Answer 6

I confirm your results again. Sorry...I never have sourced from a database before--just never occurred to me. I have always used "device" button & then picked backup file(s). This seems to work ok, populates files on 2nd tab.

sqlfriend SSC Guru Points: 52781 More actions · Answer 7

Thanks Mike for the confirm of the result.

I can choose device files to restore from too, that is no problem.

But when restore a database from another database, SQL 2012 is certainly not as handy as I used SSMS 2008. Not sure why this feature is missing.

We have some databases are basically similar on our production server for some applications.

For example We have a database called Versatrans, the other one VersatransState, VerstransPlanning

So we occasionlly need to restore database VersatransPlanning from the Versatrans, for people to work on that, so in this case, we need to restore a database from another database.

DeWayne_McCallie Hall of Fame Points: 3617 More actions · Answer 8

I used to use the SSMS GUI; however, now I am a script kiddy and use my scripts!