sql 2008 standard
restoring database but logic is not working as I expected.
production database name = premisys
want to restore a backup of premisys to about 2 days ago to a new database named premisys1 without effecting premisys in prod
in the "to database",(screenshot 1) would I put the name premisys1 (this is a database that does not exist) screenshot1.jpg
can I bullet from database and select option and select the restore point that is bulleted? screenshot1.jpg
will this create a database named premisys1 from a restore point at around 2 am on 3/24 without effecting the in prod premisys database? screenshot 2 referenced.