Jim Metcalf
asked on
restoring database with sql 2008
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
next options....
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.
screenshot-1.JPG
screenshot-2.JPG
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
next options....
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.
screenshot-1.JPG
screenshot-2.JPG
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ensure to click the Options button and rename the files also.
ASKER
thanks mohammed
question....
in the source for restore....
from database is ok to use?
from device... for some reason it won't let me select a network location....
is this normal?
I guess I don't understand the concept of backup sets versus a backup file....
from database versus device is obviously using some logic to grab the correct backup files which are located on a network drive.
so it seems I need to I can use the from database option instead of from device... and restore a new database from the production database without any effect?
question....
in the source for restore....
from database is ok to use?
from device... for some reason it won't let me select a network location....
is this normal?
I guess I don't understand the concept of backup sets versus a backup file....
from database versus device is obviously using some logic to grab the correct backup files which are located on a network drive.
so it seems I need to I can use the from database option instead of from device... and restore a new database from the production database without any effect?
From a network location is not supported as SQL server can see local drives only. Your option would be to copy the BAK file to a local drive and restore it from the local drive.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.