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
jamesmetcalf74Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
make sure to click on options and make sure to identify where the db and log files and their names are not the same.
you must use the full backup (file) without bringing the db online,  then use the transaction log back up to restore it to a time with the last bringing the new db online.
0
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
Ensure to click the Options button and rename the files also.
0
jamesmetcalf74Author Commented:
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?
0
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
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.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
From a network location is not supported as SQL server can see local drives only.
Not really a SQL Server issue but SSMS. I don't like to use the GUI for these kind of tasks. It will be more clear with T-SQL. The command should be something like:
RESTORE DATABASE premisys1
FROM DISK='C:\MSSQL\BACKUPS\Premisys_backup_full.bak'
WITH 
   MOVE 'premisys_Data' TO 'C:\MSSQL\Data\premisys1_Data.mdf', 
   MOVE 'premisys_Log' TO 'C:\MSSQL\Log\premisys1_Log.ldf'

Open in new window


NOTE: I don't know the location of the backup and the real data and tlog logical and physical filenames so you need to find those information and update the command above with the real information. If you also don't know you can easy find it by running the following command:
RESTORE FILELISTONLY
FROM DISK='C:\MSSQL\BACKUPS\Premisys_backup_full.bak'--> replace this with the correct path and filename

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.